Thanks Gerry,
but I can Create my table in memory from an attached db, I can Insert
new rows and I can Select the new rows and all values are correct,
except for my key field that is 0.
My Insert statement is INSERT INTO myTable VALUES (?,?,?);
I prepare this statement with sqlite3_prepare
I bind all values with sqlite3_bind_int, sqlite3_bind_text, ...
I bind my key field with sqlite3_bind_null
I exec with sqlite3_step
It works because if I exec e SELECT rowid,* FROM myTable I can find all
the new rows and all values except for my key field (INTEGER PRIMARY
KEY, I have tried also AUTOINCREMENT) that is 0, but rowid is correct....
I need to use a SELECT *, I can't get rowId so how and when my key field
has the same value of rowId, why it does't works?
Thanks in advanced
Luke
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
