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 <bonnm...@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@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode