I can’t figure out for the life of me why I can’t get this to select all tables.
If I select a specific table it works…
var Table="Table1";
var Columns="*";
myStatement.text = "SELECT "+Columns+" FROM "+Table;
but when I try to select all tables like this…
var Table="*";
var Columns="*";
myStatement.text = "SELECT "+Columns+" FROM "+Table;
I get this error message…
SQLError: ‘Error #3115: SQL Error.’, details:‘near ‘*’: syntax error’, operation:‘execute’, detailID:‘2003’
It seems like this should be working because in the documentation it says,
"If a result expression is * then all columns of all tables are substituted for that one expression. "
here is the docs.
http://livedocs.adobe.com/flex/3/langref/localDatabaseSQLSupport.html#dataManipulation
Anyone have an idea what I am doing wrong?
Thanks!