Re: [sqlite] autoincrement and primary key

2013-05-20 Thread Roman Fleysher
[i...@tandetnik.org] Sent: Monday, May 20, 2013 4:41 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] autoincrement and primary key On 5/20/2013 4:17 PM, Roman Fleysher wrote: > I would like to use INTEGER PRIMARY KEY, but I would like to disable its > implicit AUTOINCREMENT featur

Re: [sqlite] autoincrement and primary key

2013-05-20 Thread Igor Tandetnik
On 5/20/2013 4:17 PM, Roman Fleysher wrote: I would like to use INTEGER PRIMARY KEY, but I would like to disable its implicit AUTOINCREMENT feature. Namely, if INSERT specifies value of the column, I would like uniqueness to be enforced, but if NULL is supplied, I would like the operation to

Re: [sqlite] autoincrement and primary key

2013-05-20 Thread Jean-Christophe Deschamps
I would like to use INTEGER PRIMARY KEY, but I would like to disable its implicit AUTOINCREMENT feature. Namely, if INSERT specifies value of the column, I would like uniqueness to be enforced, but if NULL is supplied, I would like the operation to fail instead of advancing key to a new

[sqlite] autoincrement and primary key

2013-05-20 Thread Roman Fleysher
Dear SQLiters, I would like to use INTEGER PRIMARY KEY, but I would like to disable its implicit AUTOINCREMENT feature. Namely, if INSERT specifies value of the column, I would like uniqueness to be enforced, but if NULL is supplied, I would like the operation to fail instead of advancing key

Re: [sqlite] Autoincrement of primary key

2004-05-03 Thread Dynamix
gt; To: "Dynamix" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, May 03, 2004 1:36 PM Subject: RE: [sqlite] Autoincrement of primary key > > SQLITE FAQ: > > > (1) How do I create an AUTOINCREMENT field. > > Short answer: A column declared IN

[sqlite] autoincrement columns & primary key

2003-12-08 Thread Michael Hunley
I have just begun experimenting with SQLite for an embedded project. I am relatively new to this list, so apologies if this is old news. Is there an archive of the emails with a good search facility so I can check for old questions? I was trying out some table creation and insert semantics