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
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 cmsheffi...@icloud.comwrote:
Mike,
See this page in the SQLite documentation
http://www.sqlite.org/c3ref/last_insert_rowid.html. You should
Hi,
You might be able to create a trigger, which automatically executes
queries when you insert specific data.
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553
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.