Trevor did you also make sure you had a space after the name, before the opening parethesis?
NOT EXISTS " + name + "(r NOT EXISTS " + name + " (r On Tue, Dec 27, 2016 at 8:58 AM, Trevor Holman <[email protected]> wrote: > 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 > >
