Using SQL as a variable

Question

PO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TAG1000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 50501001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70701002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9090I have the above info in my SQL server table called Test.I have a spreadsheet which gives me the value (1001) for my current PO number.&nbsp; I want to be able to look in my SQL table and find the Tag number associated with PO 1001 and get back 7070 and store that as a new Variable.Anybody know of a way to do this?

sastowe · Answer

If I understand your question correctly, you will be able to use ADO (Active Data Objects) to access your SQL Server table. Google ADO for information. This is not a Test Complete or Smart Bear technology but Active X tech by Microsoft. Look ath teh connection object and the recordset object.

Forum Discussion

Using SQL as a variable

Recent Discussions

TestComplete update pending

Test wont do anything after move

TestComplete: Desktop app in Cobol and TC crash when I try to ObjectSpy it

Related Content

Specify a variable in SQL Designer

Issue using Excel and variables in name mapping

Using Dynamic SQL in TestComplete DBTable