Forum Discussion
5 Replies
Sort By
- murugans1011Regular Contributorcreate a global variable under project variables and use tat....
select member from members where id= '" & member_id & "' - griceNew ContributorThanks for the information however when I enter the value in the SQL Results I get and error stating that the value does not exsists...
- TanyaYatskovskaSmartBear Alumni (Retired)
Hi George,
Let us know from where exactly you are executing the SQL query.
- griceNew ContributorHi and thank you for helping me out.
I use the Data Loop and select the option "Use a SQL query", enter my connection credentials, and where the panel that the SQL query is supposed to go (where the user can create a query or execute a Query) this is where I put my query
Select member_id from members where id = 3
But I want to use a variable for the number 3 i.e. a global variable MemberID.... in the SQL query if it is posible in the Data Loop wizard...
Thanks,
George - TanyaYatskovskaSmartBear Alumni (Retired)
Hi George,
Try specifying the variable in the following way:
KeywordTests.Test1.Variables.Var1
However, as far as I remember, TestComplete treats an SQL query as a string, and it may not handle the variable properly.
Related Content
Recent Discussions
Check PopupMenu exists
Solved3 days agomfoster711- 4 days agosimonaferrara
- 4 days agomacheshmeh