Where to start the sqlite database?

TodayIsTheDay · Post by **TodayIsTheDay** » Mon Sep 14, 2009 10:02 pm

I'm new to Runrev and pretty much new to databases...

I've used a scripting language in the past where you would declare all global functions and any sqlite databases to be created, etc in a page that ran "onpreload" of the program (I think they called it).

My question is where do you put the initial code for the sqlite database? Do you do something similar?

I've looked over the sample for code, etc and understand most of it but this part I'm hung on...

Thanks in advance!

Janschenkel · Post by **Janschenkel** » Tue Sep 15, 2009 5:33 am

My suggestion would be to run it in a preOpenStack message handler in the first card of your mainstack. That way it is only loaded once, when your stack is opened, and you don't get any side effect from how the message path works.
URL: http://www.fourthworld.com/embassy/arti ... _path.html

You may like to download the ticket example application which I built for the RunRevLive'09 conference - the package contains the slides and code for my presentations on 'Desktop Databases with SQLite' and 'Basic Reporting & Output'. You can take the stack apart to see what makes it tick.
URL: http://www.quartam.com/downloads/tea.zip

HTH,

Jan Schenkel.