[RBG7-L] - RE: Column Constraints and Table Constraints

[Thomas Eldred]

Buddy, Alastair, Jim --- thank you all, kiling the extra plus was the 
winner.

:-D
tom
----- Original Message ----- 
From: "Walker, Buddy" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <rbg7-l@rbase.com>
Sent: Wednesday, March 09, 2005 2:14 PM
Subject: [RBG7-L] - RE: Column Constraints and Table Constraints

Tom
 Remove the plus from the last line before the alter table command.
Buddy
-----Original Message-----
From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Thomas
Eldred
Sent: Wednesday, March 09, 2005 2: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