Search found 329 matches

by jalz
Mon Feb 06, 2012 3:01 pm
Forum: Databases
Topic: data grids and sqlite
Replies: 10
Views: 3549

Re: data grids and sqlite

Hi townsend, Sorry dont want to hijack this thread, but I might be having the same problem as OP. Your CRUD file is an awesome stack by the way, Ive learned so much from it. How did you learn/get started with all the stuff in here. I've been disecting your example and understand most of it myself no...
by jalz
Mon Feb 06, 2012 2:47 pm
Forum: Databases
Topic: Data synchronising between desktop and mobile
Replies: 6
Views: 2142

Re: Data synchronising between desktop and mobile

Thanks for the insight guys. Really appreciate it, will give it some careful consideration when I create the module for the mobile version. Ive had some experience with record level synchronisation with a past project in FileMaker but to be honest it never really worked efficiently - might give the ...
by jalz
Thu Feb 02, 2012 3:10 pm
Forum: Databases
Topic: Data synchronising between desktop and mobile
Replies: 6
Views: 2142

Data synchronising between desktop and mobile

Hi Guys, Im playing around with Live Code and want to create an database app the works both on the iPhone and Mac/Windows platform. My question is I want my application to synchronise the data between the desktop version and the mobile version. I want the user to only be able to synchronise when the...
by jalz
Fri Jan 13, 2012 10:34 pm
Forum: Getting Started with LiveCode - Complete Beginners
Topic: using substacks or cards
Replies: 1
Views: 479

using substacks or cards

Hi Guys, Im fairly new to LiveCode after taking the plunge. Find it not too bad actually after coming from a different background and Ive got my first db table working ok.... still working out how to do relationships and add two records (parent, and child) together with the primary keys so they are ...
by jalz
Thu Jan 05, 2012 11:50 pm
Forum: Databases
Topic: inserting data into two tables with a keyfield
Replies: 4
Views: 949

Re: inserting data into two tables with a keyfield

Hi Mark,

Thanks - figured out that this will get the id i'm looking for:

Code: Select all

put revDataFromQuery("","",conID,"SELECT last_insert_rowid()") into tCustID
Im suprised I dont need to tell it to use which table after the select. Seems to work without it anyway :)
by jalz
Thu Jan 05, 2012 7:50 pm
Forum: Databases
Topic: inserting data into two tables with a keyfield
Replies: 4
Views: 949

Re: inserting data into two tables with a keyfield

Hi Mark, Thanks for replying. I thought database triggers were great at moving the same data from one table to another - in a shadowtable type usage or audits. I wasn't aware I could use a database script trigger in this manor - will do some reading up on this. Im thinking it maybe easier to do two ...
by jalz
Wed Jan 04, 2012 11:11 pm
Forum: Databases
Topic: inserting data into two tables with a keyfield
Replies: 4
Views: 949

inserting data into two tables with a keyfield

Hi all, As my previous thread, I've got data from text fields to populate my table. So far, Ive got 3 fields in the Customer table C_ID (Primary - Auto Increment) , FName and SName. I've got another table called Address which includes the following fields C_ID (this is going to be the keyfield that ...
by jalz
Wed Jan 04, 2012 9:03 pm
Forum: Databases
Topic: How to get contents of a field into variable
Replies: 6
Views: 4348

Re: How to get contents of a field into variable

Hi Guys,

Thanks all for taking the time out - got sturgis' example to work. mwieder thanks for the function, does make the code look more elegant, Ive made it work - but I changed the code you gave me to

Code: Select all

put "VALUES (" & q(tFName) & ", " & q(tSName) & ");" after tSQL
Thanks again

Jalz
by jalz
Wed Jan 04, 2012 9:12 am
Forum: Databases
Topic: How to get contents of a field into variable
Replies: 6
Views: 4348

Re: How to get contents of a field into variable

Hi Guys, Thanks for replying. Ive tried that but it says no such column: Jalz (Jalz being what I typed into the Name field). I've got my complete code here below with the insert command - perhaps I'm doing something majorly wrong??? I've now split the name field into FName and SName and will be addi...
by jalz
Wed Jan 04, 2012 12:34 am
Forum: Databases
Topic: How to get contents of a field into variable
Replies: 6
Views: 4348

How to get contents of a field into variable

Hi all, Im very new to LiveCode, ive got a basic sqllite db set up and can insert values that are hard coded from Live Code. My next objective is to figure out how to create forms with lists, radiobuttons, and data entry fields so the data is dynamic. I've placed a "Text Entry Field" onto my layout ...
by jalz
Tue Sep 27, 2011 9:23 pm
Forum: Databases
Topic: sqllite installation required?
Replies: 3
Views: 1461

Re: sqllite installation required?

Thankyou for a prompt reply. Will check out the resources :)
by jalz
Tue Sep 27, 2011 8:35 pm
Forum: Databases
Topic: sqllite installation required?
Replies: 3
Views: 1461

sqllite installation required?

Hi all, Ive downloaded, livecode and installed it. Been playing around with the user interface and quite like the drag and drop gui elements.I want to start experimenting with databases and I suppose I should start with sqllite and then work my way up. Do I have to install sqllite separately in orde...
by jalz
Sat Sep 13, 2008 8:42 am
Forum: Databases
Topic: FileMaker developer looking to convert
Replies: 5
Views: 3245

Thank you both of you. I can see it being a bit of a learning curve, but it does look like the right tool I need to convert my solution into a "proper" solution. I'll download trial copy of Revolution Studio and follow some examples. BvG, thankyou for the heads up on SQLite, I thought that db was sc...
by jalz
Fri Sep 12, 2008 11:16 pm
Forum: Databases
Topic: FileMaker developer looking to convert
Replies: 5
Views: 3245

FileMaker developer looking to convert

Hello, I'm not sure this is the right forum to post this message, if not please can the moderators move it. I've got a FileMaker solution which I would like to convert to runrev and SQLite(or another SQL db that is free). First thing I would like to know is, are the runtimes I create FREE to distrib...

Go to advanced search