YkHTspNK

1var connection:SQLConnection;
2
3openDatabase();
4t_phone.restrict = "0-9";
5
6function openDatabase():void
7{
8var dbFile:File = File.applicationStorageDirectory.resolvePath("database.db");
9
10
11trace(dbFile.nativePath);
12
13
14connection = new SQLConnection();
15connection.addEventListener(SQLEvent.OPEN, onOpen);
16connection.openAsync(dbFile, SQLMode.CREATE);
17}
18
19function onOpen(SQLEvent):void
20{
21var stat:SQLStatement = new SQLStatement();
22stat.sqlConnection = connection;
23trace("create table");
24stat.text = "CREATE TABLE IF NOT EXISTS contacts (id INTEGER PRIMARY KEY AUTOINCREMENT, fname TEXT, lname TEXT, phone INTEGER)";
25stat.execute(-1, new Responder(selectItems));
26}