Dani78112 wrote:
Hi Guys,
i am pretty new with the usge of database. I would like to dev a simple note app using database has refrence id for each notes.
do you have some example or tuto step by step?
Hey - I am working on notes app too ;-) welcome to the club...
here is sample AS3 code to get you started.
import flash.filesystem.File;
import flash.data.*;
var myDB:File = File.applicationStorageDirectory.resolvePath("mydatabase.db");
var sqlConn:SQLConnection = new SQLConnection();
var sqlStatement:SQLStatement = new SQLStatement();
sqlConn.open(myDB);
sqlStatement.sqlConnection = sqlConn;
sqlStatement.text = "SELECT * FROM table1";
sqlStatement.execute();
var result:Array = sqlStatement.getResult().data;
The "result"variable is an array with the result of the query where each array member is an object where value of a column is a property with the name of the column.
You can also set itemClass property on the sqlStatement to particular object class and the array objects will be returned of the type of the object you specify in the itemClass as long as the DB column names match the object properties. Its pretty exciting stuff ;-)
Hope this gets you going.
----------
If you find this post helpful please "like" it and accept as a solution.
