Thanks Mark, I have tried that. It still runs the "EXISTSKnives" as one word. I've tried adding a space in the functions that grab the input text as well.
Trevor -----Original Message----- From: Mark Kessler [mailto:[email protected]] Sent: Monday, December 26, 2016 2:06 PM To: [email protected] Subject: Re: Using a variable in a sqlite query Might it be needed a little string separation using single quotes? So the part here.... "CREATE TABLE IF NOT EXISTS " + name + " might be this. "CREATE TABLE IF NOT EXISTS '" + name + "' which has single quotes added... translating to roughly CREATE TABLE IF NOT EXISTS 'Knives' -Mark On Mon, Dec 26, 2016 at 2:58 PM, 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 >
