OK here is what I have so far:
CREATE Table #userid#
(
ID TEXT(40) NOT NULL PRIMARY KEY,
userid TEXT(40) NOT NULL,
category TEXT(10) NOT NULL,
quant TEXT(10) NOT NULL,
startprice TEXT(10) NOT NULL,
duration TEXT(2) NOT NULL,
auction_id TEXT(25) NOT NULL,
title TEXT(45) NOT NULL,
auction_date DATE NOT NULL,
ebaybidarea MEMO NOT NULL
);
This creates a table for the user with 10 fields. However I still have 2
problems.
1) The Primary Key is not set to auto number, how can I set this? Should I
be using something in place of TEXT(40) I tried using AutoNumber but that
returned errors.
2) I can't get the auction_date field to work. If I add the DEFAULT Date()
to the SQL statement I get errors.
Thanks,
Rich
------------------------------------------------------------------------------------------------
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]
