KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


Query from database with variable

Share
avatar
agent42

Posts : 2
Points : 116
Join date : 2018-11-29

Query from database with variable

Post by agent42 on Thu Jan 10, 2019 8:45 am

Hi All,

I'm trying to use the variable i created and assigned in query database SQL query. 
But it seems the studio can't detect the variable. 
Appreciate if anyone could guide on how to use variable in this case?
Variable type simple short text.

"SELECT * FROM table
WHERE field1 = variable"

Thank you.
Sean
avatar
agent42

Posts : 2
Points : 116
Join date : 2018-11-29

Re: Query from database with variable

Post by agent42 on Thu Jan 10, 2019 1:58 pm

Answer:
"SELECT * FROM table
WHERE field1 =" + variable

    Current date/time is Thu Mar 21, 2019 9:52 pm