Newbie on Livecode

[eyonmac]

Hello, it's me again ...
Is there a possibility to recover a variable in a SQL command ?
I'd like to do this :

Code: Select all

put "SELECT * from informations WHERE infos LIKE myvariable into tSQL

but I don't know how to write it.
I have created a global variable in my stack and when an item is selected in my option menu, its content goes into myvariable. That works. But I can't find how to recover the content of this variable in the sql command.
Would you have any idea ?
Thanks a lot !

[Klaus]

No idea what you mean with "recover a variable"?

But two things:
1. you do not have any "WILDCARD" in your "LIKE XYZ" statement!
2. I showed you a working example of this on the previous page:
http://forums.runrev.com/phpBB2/viewtop ... 60#p103439

[eyonmac]

Sorry, I wasn't really clear :
instead a word (apb for instance) in the sql request, I'd like to put a variable declared previously. I suppose the writing is different ?
Have I to put put quotes (apostrophe) around the variable : '%myvariable%' ? I have tried with different writings but it does not work.
Thanks a lot Klaus and have a good day

[SparkOut]

Code: Select all

put "SELECT * from informations WHERE infos LIKE" && myvariable into tSQL

or maybe

Code: Select all

put "SELECT * from informations WHERE infos LIKE %" & myvariable & "%" into tSQL

if you haven't already got the wildcard markers in the variable

[eyonmac]

Thanks a lot SparkOut !
I'm going to try this writing.
Best
Michel