Coding a dynamic database

[KMGriffiths]

I can find various commands/functions for creating tables in a database but can anyone give me the basic code to create a sql database named surveyor with 4 tables called doors, windows, height, width.

Any help would be appreciated.

Michael

[Klaus]

Hi Michael,

this is pretty straightforward SQL:
...
CREATE DATABASE surveyor
...

Check the query result and if OK then you can create your 4 tables with the necessary fields, maybe in a repeat loop


Best

Klaus

[mfstuart]

Hi Michael,
If you need a tool to manage a SQLITE database, and if you have FireFox, check FireFox's Add in manager and search for SQLite Manager, it's free.
This is what I've been using recently.

After using the manager interface, it displays the CREATE DATABASE, CREATE TABLE, and CREATE INDEX sql scripts. You can then copy each of the scripts into RunRev to then manage your applications database and tables.
I put these scripts into constants and reference them in my scripts. Works great.

HTHU,
Mark Stuart

[mwieder]

Ditto here. SQLite Manager is one of my favorite Firefox plugins.