HI To all ;
Requirement : To List the Table from given Database
I am Finding the Error while executing the following code which says there
is no sqlite_master table ,
private var masterTblStmt:SQLStatement;
private function masterCreationSuccess():void
{
masterTblStmt = new SQLStatement();
masterTblStmt.sqlConnection = conn;
var sql:String = "";
sql = "SELECT name FROM sqlite_master WHERE
type='table'ORDER BY name"
masterTblStmt.addEventListener(SQLEvent.RESULT,listTables);
masterTblStmt.addEventListener(SQLErrorEvent.ERROR,masterCreationFailed);
masterTblStmt.text = sql;
masterTblStmt.execute();
}
Also Tried the query //sql = "SELECT name FROM DBSample.sqlite_master WHERE
type='table'ORDER BY name"
and
Also tried to solve it by
conn.loadSchema();
var result:SQLSchemaResult = conn.getSchemaResult();
But i get result = null; when traced;
Can Anybody Solve? Or Does anybody know some different query to get the list
of table name from given database
Thanks and Regards
Shashank Kulkarni(09822576796),
Flex Developer,
Symphony services,Pune.
Check out some Cool Stufs : http://shashankkulkarni.wordpress.com/
"Motivation is an external, temporary high that pushes you forward.
Inspiration is a sustainable internal glow which pulls you forward"
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Flex
India Community" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/flex_india?hl=en
-~----------~----~----~----~------~----~------~--~---
