5U82YumK

1create multiple tables in an adobe air database
2private function db_opened(e:SQLEvent):void {
3    sqls.sqlConnection = sqlc;
4    sqls.text = "CREATE TABLE IF NOT EXISTS test_table ( id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT, last_name TEXT);";
5    sqls.execute();
6    sqls.text = "CREATE TABLE IF NOT EXISTS test_table2 ( id INTEGER PRIMARY KEY AUTOINCREMENT, first_name TEXT, last_name TEXT);";
7    sqls.execute();
8
9     }