LiveCode Forums.

Thanks for all your help guys. Really appreciate it.
The update script now works and updates the database.
What really confuses me is that when trying to adapt this update script to now INSERT INTO for a 'save' button, doesn't work. I have consequently gone through so many permutations of INSERT ...

Thanks jharris but I keep getting an error on the line. I've adapted it to my script:

put "UPDATE tTableName SET project_name = '" & tProjectName & "', working_title = '" & tWorkingTitle & "' WHERE theUniqueKey = '" & tUK & "'" into tSQL

Is this right? I've tried in many different ways but get ...

Guys that works great now.
Thanks so much for your help Klaus and others. Makes sense now!

A bit of progress.
I managed to get my button to connect to the sqlite database which is fine. I now have a script on an 'update' button to write data to the database which is as follows:

on mouseUp
global gConnectionID
if gConnectionID is not a number
then
answer error "Please connect to ...

HI Guys
Thanks so much for your help.
I put in the script you wrote BN and it works however, I now get a second image still coming up in the middle of the stack. In other words, having locked the size of the image container, the image goes into it but a second image appears in the middle of the ...

Hi there
Having some problems with a simple code to import an image. Basically, this script is on a browse button. The user clicks it, finds the image they want and it should then import it into an image viewer. Except, whats happening is that the image is importing into the middle of the stack and ...

BvG, in order to say "how do I use this language to achieve X", wouldn't you say it's useful to have an example somewhere of how to do this so that I know what the language for it is? I have looked and found nothing that answers the point of data from multiple fields going to an sqlite database and ...

Sorry BvG, you're right.
What I need to know is:
a) If I have 50 input fields in the interface which needs to pair with entries into an sqlite database, do I need to write individual revExecuteSQL statements for each field? All fields have been individually named for easy identification already.
b ...

Sorry, I'm still a little lost with this.
I can roughly see from this example how to connect to the database which is fine. However, rather than create random data in a list field, I need to pair text input fields in livecode with entries in a sqlite table. There is quite a few of them. Then, the ...

Thank you so much. Will take a look.

Hi There
I'm relatively new to Livecode and need some pointers towards how to read and write data to and from sqlite databases. In what I want to do, the sqlite3 databases are already written and Livecode doesn't need to create anything. Ultimately, the user fills in many different fields, each ...