09-20-2012 07:53 PM
I am wondering how to create the initial .db file in order to use SQL databases in my application. I have taken a look at the quotes examples, and while useful, it does not work without the quotes.db file that already exists in the project. I tried deleting it but that breaks the app. Opening the file shows some cryptic content that I am unable to read.
Solved! Go to Solution.
09-20-2012 11:36 PM
If you can't or don't want to use the various DDL statements in your code to create your tables (and I haven't done Cascades DB stuff yet so I'm not familiar with how you would), you could just create the database files by hand.
This would involve downloading the command line shell utility (usually called sqlite3) and invoking it, to execute the commands by hand.
c:\> sqlite3 myfile.db SQLite version 3.6.17 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table items (id integer primary key, name text); sqlite> .schema CREATE TABLE items (id integer primary key, name text); sqlite> .quit
Then you could bundle myfile.db into your app as the starting database.