Search found 11 matches

by CliveC
Mon May 30, 2011 3:28 pm
Forum: Databases
Topic: SQlite newbie question
Replies: 15
Views: 4826

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...
by CliveC
Fri May 27, 2011 7:38 pm
Forum: Databases
Topic: SQlite newbie question
Replies: 15
Views: 4826

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...
by CliveC
Fri May 27, 2011 4:36 pm
Forum: Rich Media
Topic: Import an image
Replies: 12
Views: 6276

Re: Import an image

Guys that works great now.
Thanks so much for your help Klaus and others. Makes sense now!
by CliveC
Fri May 27, 2011 3:33 pm
Forum: Databases
Topic: SQlite newbie question
Replies: 15
Views: 4826

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...
by CliveC
Fri May 27, 2011 2:37 pm
Forum: Rich Media
Topic: Import an image
Replies: 12
Views: 6276

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...
by CliveC
Fri May 27, 2011 1:02 pm
Forum: Rich Media
Topic: Import an image
Replies: 12
Views: 6276

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 ...
by CliveC
Wed May 25, 2011 7:52 pm
Forum: Databases
Topic: SQlite newbie question
Replies: 15
Views: 4826

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 ...
by CliveC
Wed May 25, 2011 7:01 pm
Forum: Databases
Topic: SQlite newbie question
Replies: 15
Views: 4826

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) ...
by CliveC
Wed May 25, 2011 6:39 pm
Forum: Databases
Topic: SQlite newbie question
Replies: 15
Views: 4826

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...
by CliveC
Wed May 25, 2011 5:24 pm
Forum: Databases
Topic: SQlite newbie question
Replies: 15
Views: 4826

Re: SQlite newbie question

Thank you so much. Will take a look.
by CliveC
Wed May 25, 2011 4:48 pm
Forum: Databases
Topic: SQlite newbie question
Replies: 15
Views: 4826

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

Go to advanced search