How can I get all records from a query?

[whuang]

Hi there,

I got TC to run a query which returns more than one records, but when I used the codes below, it complained "Could not find stored procedure 'First'.", if I comment out this line, it complained on While Not DBConnection.EOF that "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.". Can someone please help me how I can get all the results from the list? Thanks in advance!

Set DBConnection = ADO.CreateConnection
DBConnection.ConnectionString = MyStringValue
DBConnection.Open

Set Result = DBConnection.Execute(QueryToRun)
DBConnection.First
While Not DBConnection.EOF
Log.Message(Result.Fields.Item(ColumnName).Value)
DBConnection.Next
Wend
DBConnection.Close

[AlexKaras · Accepted solution]

Hi,

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/data...

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/data...

https://www.google.com/search?q=ado+recordset+iterate+records+vbscript

https://stackoverflow.com/questions/45619762/doing-stuff-for-each-record-in-a-recordset

http://www.vb-helper.com/howto_update_ado.html

[whuang]

never mind, I found the solutions here.

https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/createadoquery.html#_g...