1 Reply Latest reply on Nov 6, 2009 6:43 AM by kadaj

    SQLite row insetion error #3115

    kadaj Level 1

      I use an AIR made program called sqliteadmin.

      I created a database called myDatabase.db

      Created a table like:

       

      CREATE TABLE cs (req TEXT, res TEXT);

       

      then trying to populate:

       

      INSERT INTO cs (req, res) VALUES('Hello', 'Hi');    // Error # 3115when executing this query

       

      Any idea how to do it?

      Please help.

      Thank You

        • 1. Re: SQLite row insetion error #3115
          kadaj Level 1

          Got that solved by IqAndreas

          Its double quotes !!

          I got it!

           

          I found out an AIR App called SQLite Sorcerer. Its really cool and works as it should.
          It accepts both single and double quoted string. Anyone creating an SQLite database must really use it.
          Its my recommendation.