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]