On 28 Oct 2011, at 8:20am, Tamara Cattivelli wrote: > how can I let the database generate a generally unique id(guid, String)?
The database will generate a unique integer for the row itself whenever you save a row without specifying the id. You can insert a row then tell what integer it used using the C function 'sqlite3_last_insert_rowid()' <http://www.sqlite.org/c3ref/last_insert_rowid.html> or the SQLite function 'last_insert_rowid()' <http://www.sqlite.org/lang_corefunc.html#last_insert_rowid> SQLite has no understanding of GUIDs. By all means, generate one yourself and use it in a SQLite database, but SQLite won't generate one for you. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
