Search found 11 matches
- Mon May 30, 2011 3:28 pm
- Forum: Databases
- Topic: SQlite newbie question
- Replies: 15
- Views: 13069
Re: SQlite newbie question
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 INT...
- Fri May 27, 2011 7:38 pm
- Forum: Databases
- Topic: SQlite newbie question
- Replies: 15
- Views: 13069
Re: SQlite newbie question
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 error...
- Fri May 27, 2011 4:36 pm
- Forum: Multimedia
- Topic: Import an image
- Replies: 12
- Views: 13420
Re: Import an image
Guys that works great now.
Thanks so much for your help Klaus and others. Makes sense now!
Thanks so much for your help Klaus and others. Makes sense now!
- Fri May 27, 2011 3:33 pm
- Forum: Databases
- Topic: SQlite newbie question
- Replies: 15
- Views: 13069
Re: SQlite newbie question
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 the databa...
- Fri May 27, 2011 2:37 pm
- Forum: Multimedia
- Topic: Import an image
- Replies: 12
- Views: 13420
Re: Import an image
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 stac...
- Fri May 27, 2011 1:02 pm
- Forum: Multimedia
- Topic: Import an image
- Replies: 12
- Views: 13420
Import an image
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 ...
- Wed May 25, 2011 7:52 pm
- Forum: Databases
- Topic: SQlite newbie question
- Replies: 15
- Views: 13069
Re: SQlite newbie question
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 ...
- Wed May 25, 2011 7:01 pm
- Forum: Databases
- Topic: SQlite newbie question
- Replies: 15
- Views: 13069
Re: SQlite newbie question
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) ...
- Wed May 25, 2011 6:39 pm
- Forum: Databases
- Topic: SQlite newbie question
- Replies: 15
- Views: 13069
Re: SQlite newbie question
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 re...
- Wed May 25, 2011 5:24 pm
- Forum: Databases
- Topic: SQlite newbie question
- Replies: 15
- Views: 13069
Re: SQlite newbie question
Thank you so much. Will take a look.
- Wed May 25, 2011 4:48 pm
- Forum: Databases
- Topic: SQlite newbie question
- Replies: 15
- Views: 13069
SQlite newbie question
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 fiel...