5 Replies Latest reply on May 17, 2011 9:19 AM by Drew747

    SQLite error in Flex/Air App:

    5Systems Level 1

      I am trying to do a simple SQLite query from inside and Air application:

       

      Statement.text = 'SELECT Ingredient' +
                 'FROM Ingredients'+ 
                 'WHERE FoodCatagory_FK = 6'
      

       

      It works just fine in when I exicute the query in SQLite Manger, however in Air I get the follwoing error:

       

      SQLError: 'Error #3115: SQL Error.', details:'near 'FoodCatagory_FK': syntax error', operation:'execute', detailID:'2003'
      

       

       

      Not sure why it does not work, it seems pretty strait forward.

       

       

      Thanks,