Hi guys....kind of stuck up....really need help so bad here..
here's the situation I'm developing Air application using flex builder 3 and of course using sqlite as my database...Everything is going ok so far...Except...Sqlite dtbase mngmnt really give me headache...because I dont have idea where to find my dtbase was created using code...fyi I'm using SQLite sorcerer Air application SQLITE dtbase mngmnt which is so great...so when i try to browse to see my database....I'm lost here...where exactly the database was place when we created using code ..so that I can manage the table using this SQLite sorcerer...
code:
conn = new SQLConnection();
var dbFile:File = File.applicationStorageDirectory.resolvePath("DBSa mple.db");
try{
trace("database was created");
conn.open(dbFile);
}catch(error:SQLError){
trace("Error message:", error.message);
trace("Details:", error.details);
}
as well as to see my table also
stmt = new SQLStatement();
stmt.sqlConnection = conn;
var sqlcreatetbl:String = "CREATE TABLE IF NOT EXISTS user (" +
" userId INTEGER PRIMARY KEY AUTOINCREMENT, " +
" test TEXT " +
")";
stmt.text = sqlcreatetbl;
try{
stmt.execute();
}catch(error:SQLError){
trace("Error message:", error.message);
trace("Details:", error.details);
}
Hope someone will shed me some light ...and sorry for this silly question...
tq in advanced..Really need help