me 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 that there is a way wit
- 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 for.
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 < 0xFF
. 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 Keating&quo
"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
Original Message-
From: Brett Keating [mailto:[EMAIL PROTECTED]
Sent: Sunday, January 14, 2007 5:14 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Restricting integer primary key values
Hi,
I'm interested in the ability to restrict the values my integer primary
key is allowed to take. Specifical
Hi,
I'm interested in the ability to restrict the values my integer primary
key is allowed to take. Specifically, I would like to restrict the value
to be between (but not including) 0x and 0x. In other
words, a 32 bit number where all zeroes and all ones is not allowed. Is
this
7 matches
Mail list logo