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

agent42

Posts : 2
Points : 52
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

agent42

Posts : 2
Points : 52
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 Wed Jan 16, 2019 10:19 pm