flex-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Dove <greg.d...@gmail.com>
Subject Re: Using a variable in a sqlite query
Date Mon, 26 Dec 2016 20:39:43 GMT
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 <trevorh@mchsi.com> 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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message