Question I should be able to figure out but..

Mike Bonner bonnmike at gmail.com
Tue Jul 30 12:22:08 EDT 2013


Ty ty both!  Will check out both methods and see which is easiest for me to
grok. Much appreciated.


On Tue, Jul 30, 2013 at 10:19 AM, Chris Sheffield <cmsheffield at icloud.com>wrote:

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



More information about the use-livecode mailing list