Put the resutl of an SQL query in an array
Hi Guys, I have been trying all morning to make a "select" function that returns an array containing the results of a MSSQL query. This is to ease up all the complexity of the connection and the...
Forum Discussion
Using ADO objects, a select query returns an RecordSet object if more than one result is returned. So, if you want to go through the records in that RecordSet, you would iterate through a "while" loop while the RecordSet is not EOF.
See the example at https://support.smartbear.com/testcomplete/docs/reference/program-objects/ado/createadoquery.html
If you want specific help with your code, please post your code here and we'll see what we can do to help.