Re: [sqlite] autoincrement and integer primary key

2006-11-16 Thread Mario Frasca
[EMAIL PROTECTED] wrote: In the FAQ's on the web site it indicated that when the primary key is autoincrement, the data type is a signed 64 bit number. Has this been your experience? never noticed... not in Python with the sqlite modules I have... and no difference whether I use the 'auto

Re: [sqlite] autoincrement and integer primary key

2006-11-15 Thread gwithrow
In the FAQ's on the web site it indicated that when the primary key is autoincrement, the data type is a signed 64 bit number. Has this been your experience? Gary W Withrow Senior Software Engineer HID Global 11674 N. Huron Northglenn, CO 80234 303-453-4020 - Office 303-378-7647 - Cell "We are

Re: [sqlite] autoincrement and integer primary key

2006-11-15 Thread Mario Frasca
just a few explainatory notes from me to myself, hoping that they might be useful for the community... again about integer primary key autoincrement, with some details about last_insert_rowid() and sqlite_sequence. --- e