Hi all,
I have been using SQLite, the code looks like this:
[lua]local tablefill = “INSERT INTO mytable VALUES ( NULL, ‘title’);”
db:exec(tablefill)
local get = “SELECT * FROM mytable WHERE title=”…myTitle…";"
for row in db:nrows( getAddSql ) do
Item.id = row.id
end[/lua]
The first column(id) is the primary key, so it should auto_increase whenever I insert a row.
It works perfect on iOS5, but on iOS6.0.0 and iOS6.0.1 devices(either iPhone or iPad), the auto_increment seems malfunctioning, the value of id is always nil. Has anyone encountered similar problem? [import]uid: 180793 topic_id: 33654 reply_id: 333654[/import]