Tom,
Instead of
ALTER TABLE 'hwycrcreg' autonum 'regnumber' IN 'hwycrcreg' USING 101 1 9
NUM
Try this:
AUTONUM `REGNUMBER` IN `hwycrcreg` USING 101,1
Also, use ` instead of ' or use nothing
Or this:
AUTONUM REGNUMBER IN hwycrcreg USING 101,1
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Eldred
Sent: Wednesday, March 09, 2005 1:15 PM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Column Constraints and Table Constraints
HI everyone....
I am working on a table, trying to get it to autonumber the rows, but i get
an error indicating that table constraints must follow column constraints. I
am not sure what i am missing as i copied the format of a table i made in
Database Explorer.
Here is the code, I'd appreciate knowing what i am missing.
Tom
CREATE TABLE hwycrcreg +
(bregnumber INTEGER NOT NULL ('Value for column locationnumber cannot be
null') , +
bfirstname TEXT 30, +
blastname TEXT 30, +
bprefname TEXT 30, +
bfullname TEXT 60, +
bgender TEXT 1, +
bstafftitle TEXT 30, +
brushnumber INTEGER, +
bofficename TEXT 30, +
bshortname TEXT 30, +
beventone TEXT 1, +
beventtwo TEXT 1, +
bsgfirst TEXT 30, +
bsgfullname TEXT 30, +
bpaidsg TEXT 1, +
bregcancel DATE, +
bsgcancel DATE, +
blatereg TEXT 1, +
bregnotes NOTE) +
ALTER TABLE 'hwycrcreg' autonum 'regnumber' IN 'hwycrcreg' USING 101 1 9
NUM
