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?
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.