I am trying to get the record count for this query
Set objConn = CreateObject("ADODB.Connection")
Set objRS = CreateObject("ADODB.Recordset")
objRS.ActiveConnection = objConn
objRS.Source = "Select * from TEST123 where Price = 16"
but it always print -1, even if I change the query to some other where clause, it still prints -1.
Is there another way to do it?
"God doesn't play dice" - Einstein
Search the forum first from next time (a bit harder if you did already)
Buy the NEW QTP Descriptive Programming Unplugged Book
** Download QTP Unplugged 2nd Edition eBook for FREE **
Add this to your code.
objRS.CursorType = 1
Thanks Tarun and TReddy. I got my answers.