RE: [sqlite] INTEGER PRIMARY KEY Auto Increment Rollover Question

>> Brickl Roland [mailto:[EMAIL PROTECTED] wrote: >> Integer PrimaryKeys are always autoincrementing. When you don't >> specify it it uses after (2^63)-1 a random free positiv value. >> "Odekirk, Shawn" <[EMAIL PROTECTED]> wrote: >> I will compile this for Windows and see what my results are using

RE: [sqlite] INTEGER PRIMARY KEY Auto Increment Rollover Question

Brickl Roland [mailto:[EMAIL PROTECTED] wrote: > Integer PrimaryKeys are always autoincrementing. When you don't > specify it it uses after (2^63)-1 a random free positiv value. "Odekirk, Shawn" <[EMAIL PROTECTED]> wrote: > I will compile this for Windows and see what my results are using a > comp

Re: [sqlite] INTEGER PRIMARY KEY Auto Increment Rollover Question

"Odekirk, Shawn" <[EMAIL PROTECTED]> wrote: > My compiler is old and I don't think it supports a 64 bit data type. > Maybe this is the root cause of my problem. > Very likely. -- D. Richard Hipp <[EMAIL PROTECTED]> -

RE: [sqlite] INTEGER PRIMARY KEY Auto Increment Rollover Question

October 13, 2007 5:29 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] INTEGER PRIMARY KEY Auto Increment Rollover Question Hallo Odekirk Shawn, SQLite use up to an 64Bit signed Integer for Primary Keys, even on non 64Bit-Systems! Integer PrimaryKeys are always autoincrementing. When you don't s

RE: [sqlite] INTEGER PRIMARY KEY Auto Increment Rollover Question

Hallo Odekirk Shawn, SQLite use up to an 64Bit signed Integer for Primary Keys, even on non 64Bit-Systems! Integer PrimaryKeys are always autoincrementing. When you don't specify it it uses after (2^63)-1 a random free positiv value. When you write autoincrement for your create table it never r