Question I should be able to figure out but..

[Chris Sheffield]

Mike,

See this page in the SQLite documentation http://www.sqlite.org/c3ref/last_insert_rowid.html. You should be able to call last_insert_rowID() via a Select statement in LiveCode script. That'll get you the rowid value, which you can then use to insert records in your other two tables.

Chris



--
Chris Sheffield
Read Naturally, Inc.
www.readnaturally.com



On Jul 30, 2013, at 10:04 AM, Mike Bonner <bonnmike at gmail.com> wrote:

> I have a question that should be easy to figure out but i'm having issues
> so hopefully someone can point me at a simple method.
> 
> I have an sqlite database with 3 tables, 1 primary, with the other 2 as
> secondary tables that relate to the primary with an id field.
> 
> The question is this.. can I create an entry in the primary as well as
> adding entries to the secondaries all in one go?  Need to create the main,
> use the newly created id and add the entries to the secondary tables using
> that id.
> 
> I've done this (or similar) in the past yet can't get my noggin to pull out
> the info, and haven't found the right thing via google yet. (will keep
> looking for the right words to google)
> 
> Any help would be appreciated.
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode