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.
Chr
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
U
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 wrote:
> Mike,
>
> See this page in the SQLite documentation
> http://www.sqlite.org/c3ref/last_insert_rowid.html. You should be able to
> call la
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
