Tom, Use AUTONUM rather than ALTER TABLE:
AUTONUM regnumber IN hwycrcreg USING 101 1 9 NUM Regards, Alastair. ----- Original Message ----- From: "Thomas Eldred" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, March 09, 2005 7:15 PM 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 >
