LiveCode Forums.

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

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 ...

Hello, it's me again ...
Is there a possibility to recover a variable in a SQL command ?
I'd like to do this :
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 ...

That's it ! Well, I love this software !

Thanks a lot Klaus, it works perfectly !
Would you have any idea in order to connect to database at the opening of the application without clicking on the button ?
I have found !
Well, perhaps it will be useful for other newbies as me :
- in object Menu, select "Stack script" and type the command ...

Bonjour Klaus,
Thanks a lot for your help !
1 - Yes, I 've forgotten the comma in the line (it's the second day only I work on Livecode ...) and I have deleted it as it seems to work.
2 - Super ! I agree with you : my text is effectively multi-line. So, ok, I've deleted the return and put the ...

Hello Klaus,
That's good ! It works perfectly !
The problem came from another software with which I opened the sqlite database : it took only the first line on one record !
In Livecode, I put another field for the preview of the data and there I really have all the lines of my text registered in ...

It was just an exemple. Here is the content of the field :

Exemple de phrase tapée dans le champ intitulé Saisie

Seconde phrase tapée dans le champ

Thanks a lot and have a good night

Bonsoir Klaus,
Do you speak french ?
I've also tried this :
repeat for each item champsaisie in saisie
put "INSERT into informations VALUES ('" & champsaisie & "');" into tSQL ,
but it gives the same thing and not sure the code is correct.
Here is the code in my card :
local sDatabaseID
## la ...

Excuse me, another question :
in the database, there's only the first line I have written in the field, but not all the line (5 lines separated by return key). How can I do to take it all ?
Thanks a lot again !

Thanks a lot Klaus !
It works perfectly !!
Have a goo day !

Hello,
Sorry for my bad english language ...
I try to build a little database in order to keep specific informations and I have used the step-by-step guide How to create and use an SQLite database. It works perfectly, but I would want to modify something. In the code, we insert the data by the sql ...