Please help me refine the following SQL. I have pretty much all the C code in place, table creation & detection works, then.. brick wall.
I cannot add a single small text string into the table. What am I doing wrong? Trying with the "UPDATE '%q' SET val=?2 WHERE key=?1;" string, where ?1 and ?2 and bound to text strings.
SQLite says SQLITE_DONE, but so does reading the table (= no data). Also sqlite3 cmdline tool confirms the emptiness.
Asko,
I think your problem is that you are expecting UPDATE to insert a new record into the table. It won't do that. UPDATE is used to modify columns of records that already exist in the table. To insert new data into a table you need to use the INSERT command.
CREATE TABLE ini (key, value)
INSERT INTO ini VALUES('my key', 'some value')UPDATE ini SET value = 'another value' WHERE key = 'my key'
SELECT * FROM ini
