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

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

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

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

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

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