I did. I also had it with no space and the open parenthesis was enough to separate the character. I've tried using the concat() function with the input field.text but it seems to strip out the space. The only thing that has worked is adding the space in the input field before I type the name...
I've tried breaking down the query as well in separate lines but again it wants to close that gap after the "EXISTS" command. -----Original Message----- From: Greg Dove [mailto:[email protected]] Sent: Monday, December 26, 2016 2:40 PM To: [email protected] Subject: Re: Using a variable in a sqlite query 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 > >
