Query MS-SQL database through TC
Hi, Using below code, I'm trying to query a table in MS-SQL server, it is giving me table fieldnames but it is not displaying the data from each field. Sub TestSQL 'Creates ADO conn...
Forum Discussion
The following line will not output anything
aRecSet is a recordset data type where you need to grab the data from fields and display it. If there is more than one row, you then need to interate through the recordset using a MoveNext command to move to the next row. Simply logging the aRecSet object to the log won't do anything.
Log.Message aRecSet
aRecSet is a recordset data type where you need to grab the data from fields and display it. If there is more than one row, you then need to interate through the recordset using a MoveNext command to move to the next row. Simply logging the aRecSet object to the log won't do anything.