"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 < 0xFFFFFFFF)" 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. >
SQLite does not support hexadecimal constants. Use 4294967295 instead of 0xFFFFFFFF and it should work. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------