TE7Uafms

1how to create multiple tables in same database in SQLite on mobile application?
2private var db:File = File.userDirectory.resolvePath("DataBase.sql");
3        private var conn:SQLConnection;
4        private var createTableStmt:SQLStatement;
5        private var createTableSQL:String =
6            "CREATE TABLE IF NOT EXISTS RecipeDB (" +
7            "RecipeID INTEGER PRIMARY KEY AUTOINCREMENT," +
8            "Name VARCHAR(20)," + "Category VARCHAR(20)," + "Origin VARCHAR(20)," + "Recipe VARCHAR(2000)," + "Favorite BOOL)";
9
10        private var selectStmt:SQLStatement;
11        private var selectSQL:String = "SELECT * FROM RecipeDB";
12        private var insertStmt:SQLStatement;
13        private var insertSQL:String =
14            "INSERT INTO FoodDish2 (Name, Category, Origin, Recipe)" +
15            "VALUES (:Name, :Category, :Origin, :Recipe)";
16        protected function application1_applicationCompleteHandler
17        (event:FlexEvent):void
18        {
19            conn = new SQLConnection();
20            conn.addEventListener(SQLEvent.OPEN, openHandler);
21            conn.addEventListener(SQLErrorEvent.ERROR, errorHandler);
22            conn.openAsync(db);
23        }
24        private function openHandler(event:SQLEvent):void {
25            log.text += "Database opened successfully";
26            conn.removeEventListener(SQLEvent.OPEN, openHandler);
27            createTableStmt = new SQLStatement();
28            createTableStmt.sqlConnection = conn;
29            createTableStmt.text = createTableSQL;
30            createTableStmt.addEventListener(SQLEvent.RESULT, createResult);
31            createTableStmt.addEventListener(SQLErrorEvent.ERROR,
32                errorHandler);
33            createTableStmt.execute();
34        }
35	
36private var createTableSQL:String ="CREATE TABLE IF NOT EXISTS RecipeDB(
37RecipeID INTEGER PRIMARY KEY AUTOINCREMENT,
38Name VARCHAR(20),
39Category VARCHAR(20),
40Origin VARCHAR(20),
41Recipe VARCHAR(2000));
42
43CREATE TABLE IF NOT EXISTS IngredientDB(
44RecipeID INTEGER REFERENCES RecipeDB(RecipeID),
45Ingredient VARCHAR(20),
46Quantity VARCHAR(20));"
47	
48private var db:File = File.userDirectory.resolvePath("DataBase.sql");
49private var conn:SQLConnection;
50private var createTableStmt:SQLStatement;
51private var createTableRecipeSQL:String =
52    "CREATE TABLE IF NOT EXISTS RecipeDB (" +
53    "RecipeID INTEGER PRIMARY KEY AUTOINCREMENT," +
54    "Name VARCHAR(20)," + "Category VARCHAR(20)," + "Origin VARCHAR(20)," + "Recipe VARCHAR(2000)," + "Favorite BOOL)";
55
56private var createTableIngredientSQL:String =
57    "CREATE TABLE IF NOT EXISTS IngredientDB(" +
58    "RecipeID INTEGER REFERENCES RecipeDB(RecipeID)," +
59    "Ingredient VARCHAR(20),Quantity VARCHAR(20))";
60
61......
62
63private function openHandler(event:SQLEvent):void {
64    log.text += "Database opened successfully";
65    conn.removeEventListener(SQLEvent.OPEN, openHandler);
66    createTableStmt = new SQLStatement();
67    createTableStmt.sqlConnection = conn;
68    createTableStmt.text = createTableRecipeSQL;
69    createTableStmt.addEventListener(SQLEvent.RESULT, createResult);
70    createTableStmt.addEventListener(SQLErrorEvent.ERROR, errorHandler);
71    createTableStmt.execute();
72
73    createTableStmt = new SQLStatement();
74    createTableStmt.sqlConnection = conn;
75    createTableStmt.text = createTableIngredientSQL;
76    createTableStmt.addEventListener(SQLEvent.RESULT, createResult);
77    createTableStmt.addEventListener(SQLErrorEvent.ERROR, errorHandler);
78    createTableStmt.execute();
79}