Re: [sqlite] A matter of UNIQUEness

2012-07-23 Thread Igor Tandetnik
Arbol One wrote: > When using the statement 'UNIQUE INTEGER val', does SQLite3 automatically > create a unique integer value for the transaction or would it only > ascertain the uniqueness within that column? > > i.e.: > > Glib::ustring sql_param_tblName = "CREATE TABLE name(n_id INTEGER PRIMAR

Re: [sqlite] A matter of UNIQUEness

2012-07-23 Thread Cory Nelson
On Mon, Jul 23, 2012 at 8:35 AM, Arbol One wrote: > When using the statement 'UNIQUE INTEGER val', does SQLite3 automatically > create a unique integer value for the transaction or would it only > ascertain the uniqueness within that column? > > > > i.e.: > > Glib::ustring sql_param_tblName = "C

[sqlite] A matter of UNIQUEness

2012-07-23 Thread Arbol One
When using the statement 'UNIQUE INTEGER val', does SQLite3 automatically create a unique integer value for the transaction or would it only ascertain the uniqueness within that column? i.e.: Glib::ustring sql_param_tblName = "CREATE TABLE name(n_id INTEGER PRIMARY KEY, title TEXT, fname TEX