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
Coding a dynamic database
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 7
- Joined: Thu Aug 06, 2009 7:32 am
Coding a dynamic database
Michael Griffiths
-
- Livecode Opensource Backer
- Posts: 16
- Joined: Sun Apr 09, 2006 9:49 pm
- Location: Irvine, CA, USA
re: Coding a dynamic database
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
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