RE: [sqlite] Restricting integer primary key values

happen in my lifetime but hey you never know). Thanks for the replies, Brett -Original Message- From: w b [mailto:[EMAIL PROTECTED] Sent: Monday, January 15, 2007 11:42 AM To: sqlite-users@sqlite.org Subject: RE: [sqlite] Restricting integer primary key values Hi Brett, I dont think tha

Re: [sqlite] Restricting integer primary key values

Clark - Original Message From: w b <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, January 15, 2007 11:41:39 AM Subject: RE: [sqlite] Restricting integer primary key values Hi Brett, I dont think that there is a way within Sqlite to automagically do what you are looking

RE: [sqlite] Restricting integer primary key values

ent: Sunday, January 14, 2007 6:09 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Restricting integer primary key values "Brett Keating" wrote: > Hi, > > I don't want to spam the list but basically, if "id INTEGER PRIMARY > KEY CHECK (id > 0 and id < 0x

RE: [sqlite] Restricting integer primary key values

taken. I will continue trying other things in the meantime. Thanks, Brett -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, January 14, 2007 6:09 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Restricting integer primary key values "Brett Keatin

Re: [sqlite] Restricting integer primary key values

"Brett Keating" <[EMAIL PROTECTED]> wrote: > Hi, > > I don't want to spam the list but basically, if "id INTEGER PRIMARY KEY > CHECK (id > 0 and id < 0x)" or something along those lines will > work, please let me know. It's not clear if sqlite3 supports checks on > primary keys from what I

RE: [sqlite] Restricting integer primary key values

Hi, I don't want to spam the list but basically, if "id INTEGER PRIMARY KEY CHECK (id > 0 and id < 0x)" or something along those lines will work, please let me know. It's not clear if sqlite3 supports checks on primary keys from what I can tell. Thanks, Brett -Original Message- F