Posted to tcl by gwlester at Wed Nov 28 15:29:25 GMT 2007view pretty

The following is giving an error "near ActivityId":

create table ActivityCode (
    ActivityId      INTEGER CONSTRAINT pkActivityCode PRIMARY KEY AUTOINCREMENT,
    ActivityName    TEXT,
    Description     TEXT,
    Active          TEXT,
    UNIQUE ActivityId
)

And I can see why!