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.