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

  1. The following is giving an error "near ActivityId":
  2.  
  3. create table ActivityCode (
  4. ActivityId INTEGER CONSTRAINT pkActivityCode PRIMARY KEY AUTOINCREMENT,
  5. ActivityName TEXT,
  6. Description TEXT,
  7. Active TEXT,
  8. UNIQUE ActivityId
  9. )
  10.  
  11. And I can see why!