import flash.filesystem.File;import flash.data.SQLConnection;import flash.events.SQLEvent;import flash.events.SQLErrorEvent;import flash.data.SQLStatement;
var conn:SQLConnection = new SQLConnection();var query:SQLStatement;var dbFile:File;var queryText:String;
dbFile = File.applicationDirectory.resolvePath("test.db");
conn.addEventListener(SQLEvent.OPEN, dbOpened);conn.addEventListener(SQLErrorEvent.ERROR, dbError);
conn.openAsync(dbFile);function dbOpened(e:SQLEvent):void{ createTable();}function dbError(e:SQLErrorEvent):void{ trace("Error DB"); trace(e.error);}function createTable():void{ query = new SQLStatement(); query.sqlConnection = conn; queryText = "CREATE TABLE IF NOT EXISTS 'website' ( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, url TEXT )"; query.text = queryText; query.addEventListener(SQLEvent.RESULT, queryResult); query.addEventListener(SQLErrorEvent.ERROR, queryError); query.execute();}function queryResult(e:SQLEvent):void{ trace("table created.");}function queryError(e:SQLErrorEvent):void{ trace("Error QUERY"); trace(e.error);}
btnSave_mc.addEventListener(MouseEvent.CLICK,testSave);function testSave(e:Event){ var connection : SQLConnection = new SQLConnection(); connection.open(website); connection.attach(secondDbFile, "website"); var statement : SQLStatement = new SQLStatement(); statement.connection = connection; statement.text = "Insert into website(name,url) values('test', 'test1')"; statement.execute(); trace("Your data is saved.");}