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
Use Color Converter to convert CMYK, RGB, RAL, XYZ, H.Lab and other
colour spaces. http://www.color-converter.com
Buy my new book "Programming LiveCode for the Real Beginner"
http://qery.us/3fi
Fill out this survey please
http://livecodebeginner.economy-x-talk.com/survey/
On 7/30/2013 18:04, Mike Bonner 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
