Page 1 of 1
Coding a dynamic database
Posted: Sun Aug 09, 2009 7:58 am
by 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
Posted: Sun Aug 09, 2009 2:03 pm
by 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
re: Coding a dynamic database
Posted: Thu Aug 20, 2009 9:10 pm
by 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
Posted: Fri Aug 21, 2009 1:51 am
by mwieder
Ditto here. SQLite Manager is one of my favorite Firefox plugins.