The best way is to execute the expression thru a SQl statement. Use dummy table.
For Example
text1.text="3*12/8, or 5*Sin(40)"
xStr=text1.text
set rs=mycon.execute ("select top 1" & xstr " from table1")
xresult=rs.fields(0)
Hope this would solve your problem.
mycon.open Provider=SQLOLEDB.1;Integrated Security=SSPI;OLE DB Services = -2;Persist
Security Info=False;Initial Catalog=Products;Data Source=local
mycon.execute "sp_setapprole 'productrole','password'"
set rs=mycon.execute("select * from product")
set rs1=mycon.execute("select * from product")...
Hi Friends
I am trying to use application role based priviliges to my users. After connecting to the database (SQL) through windows authentication, I have set the application role by executing the sp_setapprole stored procedure. I am getting rights for executing a query for once. When I am...
My task is to change header, footer and left/right/top/bottom margins from JavaScript on print form of the page in Internet Explorer.
(Not confuse with margins in the tag <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">)
For example, by default when printing a page Internet...
Hi All
We are using Nt authentication of the user to connect to the DB from the VB application. Then runs sp_setapprole procedure to activate the application role and the set the rights on tables and other objects. It is working fine with normal connection and recordset.
But how do we use...
Hi
We use application roles with Nt authentication to connect to the Database and access the tables in SQL. The connection string uses the Nt authentication to connect to the DB and runs the sp_setapprole procedure to set the rights thru applicatuon role. It works fine with connection and...
I have an application which uses Image Scan/Image Edit components (Kodak). It works fine under WIN 98.
But it does not work under WIN 2K / WIN XP as these components are not compatable with WIN 2K/XP. Is Image Scan/Image Edit components are available for WIN 2K/XP. Is there any other component...
Hi Friends
I have a client who uses a HP laserjet Network Printer. It has been installed as network printer not through any port of the Computer. We need to develop a software whicch will access the queue of the print server and store that details and at the end of the day generate a report on...
Hi
We found the cause. We have added mscal.ocx as part of the project and it is also becomes part of the setup. And this mscal.ocx creates the error. We have removed mscal.ocx from the setup and it is working fine now.
thanks for your efforts
Hi
I am encountering a problem while running the setu program. Towards the end of the setup, it returns an error saying
"C:\WINDOWS\TEMP\msftqws.pdw\${DLLSelfRegisterEx}' could not be registered because it was not found."
Thanks in advance
Julian Date format is to store the date in 5 digits. First 2 digits represents the year part and next 3 part the day part. For example 30-jan-2003 will be represented as 03030 because 30 th jan is 30th day of the year. 01-Jun-2003 will be represented as 03152. 01-June is 152 th day of th year...
We are in windows 98 network. Is there anyway I can check whether anybody in the network is connected to my shared folder. Or an alert when somebody tried to connect to my shared folder.
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.