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

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 >

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

ubject: 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

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