2 Replies Latest reply on Jun 27, 2012 12:50 AM by Umal Kumar

    SQLite error #3115 in Flex/Air App: with (')

    Dhaval (Dotsquares) Level 1

      Hi,

       

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

       

       

      var sqls:SQLStatement = new SQLStatement();
      
      sqls.sqlConnection = sqlc;
      
      sqls.text = "UPDATE videos SET thumb = 'ram's' where id = 2";
      
      sqls.execute();
      
      

       

      I need to add ' same as ram's

       

      Error:

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

       

      I'm using "addslashes()" but not working

       

      Not sure why it does not work. Please help me.

       

      Thanks,

      Dhaval