| || |
Can we use select statement in descriptive mode..
I am new at using QTP.
I am using vbscript to connect database.
Can i use a select statment to get a particular value and assign it to the variable for the future use.
(I am already using update and it works fine)
Set objConnection = CreateObject("ADODB.Connection")
objConnection.ConnectionString = "DSN=PostgreSQL ANSI;DATABASE=1128;SERVER=summer ;PORT=5432;UID=sand;PWD=2222"
objconnection.Execute "update department set status='active' where departmentid = 159159"
Thanks in advance.
Re: Can we use select statement in descriptive mode..
Yes. Assign the recordset to an variable then use that variable to get value.