How to call the result of SQL querry as from the variable?
Hi,
I created the Database query variable. My query returns me a good result(1 raw and 6 columns.) in View Table window.
But I don't understand how can I call it in my script as a String.
JavaScript
Var result = Project. Variables. MyVariable_Name;
Log. Message(“SQL response is “ + result);
In log I have: SQL response is [object COMObject] 9:34:33 Normal
How can I get it as normal String? In ideal case separated by something(/).
You will need to actually write some code to read out the data in the variable. It's not going to be able to convert the object (which is an SQL data record set) to a string directly.
See the following for an example:
https://support.smartbear.com/testcomplete/docs/testing-with/variables/data-types/db-table.html#Working