Thanks Ghazi, I'll take a look at that. Trevor
-----Original Message----- From: Ghazi Triki [mailto:[email protected]] Sent: Monday, December 26, 2016 2:14 PM To: [email protected] Subject: Re: Using a variable in a sqlite query Hello, Did you try using this library I developed? https://github.com/riadvice/ActiveAIRCord/tree/master/ActiveAIRCord It uses the Active Record (anti-pattern) and work pretty well. Some features are not implemented yet, I would be happy to improve it. Cordialement, Ghazi Triki Le 12/26/2016 à 21:05, Mark Kessler a écrit : > 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 >>
