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
