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
Hi Robert...
Its been a while I dint work on this issue... I have a query on Log.Message
Actually what I observed is as below...
Example1:
The below log is displaying details of Code field only. It is not displaying details of Module field. The example given in CreateADOQuery is as below...
Log.Message bCon.FieldByName("Code").Value, bCon.FieldByName("Module").Value
Example2:
As shown below after using '&' symbol in between each field, I'm getting expected output
The below log will display all the details of Code and Module fields from database
Log.Message bCon.FieldByName("Code").Value &" | " &bCon.FieldByName("Module").Value
Its been a while I dint work on this issue... I have a query on Log.Message
Actually what I observed is as below...
Example1:
The below log is displaying details of Code field only. It is not displaying details of Module field. The example given in CreateADOQuery is as below...
Log.Message bCon.FieldByName("Code").Value, bCon.FieldByName("Module").Value
Example2:
As shown below after using '&' symbol in between each field, I'm getting expected output
The below log will display all the details of Code and Module fields from database
Log.Message bCon.FieldByName("Code").Value &" | " &bCon.FieldByName("Module").Value