you shouldn't specify the lenght of date field (it's a date, not a text), so

CREATE TABLE EventLog
  (
 ID COUNTER
  CONSTRAINT ID PRIMARY KEY,
  Domain TEXT 128,
  IP TEXT 40,
  Action TEXT 10,
  xDate DATE,
  Info TEXT 255
  )

or

CREATE TABLE EventLog
  (
 ID COUNTER
  CONSTRAINT ID PRIMARY KEY,
  Domain TEXT 128,
  IP TEXT 40,
  Action TEXT 10,
  xDate DATETIME,
  Info TEXT 255
  )


Al

------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message 
with 'unsubscribe' in the body to [EMAIL PROTECTED]

Reply via email to