Hello, 

 

I have been struggling with this for some time. Everything I've tried and
googled has not helped. 

 

var query:String = "CREATE TABLE IF NOT EXISTS " + name + "(recid INTEGER
PRIMARY KEY AUTOINCREMENT, object_name TEXT)";

The variable "name" is used to create tables by the user. In the main Flex
file I use an input field to pass the name into the query string. The
problem is that I can't seem to separate the query command to create the
table from the actual table name unless I add the space in the input field
itself. 

 

Error #2044: Unhandled SQLErrorEvent:. errorID=3115, operation=execute ,
message=Error #3115: SQL Error. , details=near 'EXISTSKnives': syntax error

 

I've tried concatenating a space everywhere I can think of without any luck.


 

Trevor

Reply via email to