Thanks to all.
On 18/01/2012 14:53, Petite Abeille wrote:
Or just use last_insert_rowid() directly in the next insert statement. That
will reuse the rowid of the previous insert for the new one. And both row will
end up with the same id, keeping your source table and its R*Tree index in
synch.
*Splendid* idea, one for the FAQ surely.
Presumably this can be used in a binding string as in this?
"INSERT INTO gps_index (auto_id,minX, maxX,minY, maxY)
VALUES(last_insert_rowid(), ?, ?, ?, ?)"
Thank you :)
Jerry.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
