1) Try using counter as the datatype for the field you want to be autonumber
2) Puzzling me....I'll have a think!!
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
http://www.thoughtbubble.net
------------------------------------------------------------------
United Kingdom
http://www.thoughtbubble.co.uk/
Tel: +44 (0) 20 7387 8890
------------------------------------------------------------------
New Zealand
http://www.thoughtbubble.co.nz/
Tel: +64 (0) 9 419 4235
------------------------------------------------------------------
The information in this email and in any attachments is confidential and
intended solely for the attention and use of the named addressee(s). Any
views or opinions presented are solely those of the author and do not
necessarily represent those of Thoughtbubble. This information may be
subject to legal, professional or other privilege and further distribution
of it is strictly prohibited without our authority. If you are not the
intended recipient, you are not authorised to disclose, copy, distribute, or
retain this message. Please notify us on +44 (0)207 387 8890.
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: 03 November 2000 16:44
To: CF-Talk
Cc: [EMAIL PROTECTED]
Subject: RE: Create Table SQL
This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C0458B.5EE2DAB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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
------=_NextPart_000_0000_01C0458B.5EE2DAB0
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"
eJ8+IgYQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCwADAAsALAAAAAUAIQEB
A5AGAPwGAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAAFQAAAFJFOiBDcmVhdGUgVGFibGUgU1FMAAAAAAIBcQABAAAAFgAAAAHARbVFxlHiaAhYm02M
rFWE3byy24EAAAIBHQwBAAAAGAAAAFNNVFA6SUJUT0FEQFBVTktBU1MuQ09NAAsAAQ4AAAAAQAAG
DgAIFUS1RcABAgEKDgEAAAAYAAAAAAAAANaQ1++mswRGj2g2rkmyT1nCgAAACwAfDgEAAAACAQkQ
AQAAAI4CAACKAgAA9QMAAExaRnUvQwIcAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBj
aArAc7BldDAgBxMCgH0KgZJ2CJB3awuAZDQMYA5jAFALAwu1IE9LIJJoBJBlIAQAIHcQ8CUFQEkT
8GF2FDBzb3QgZgrAOgqiCoQKgEOAUkVBVEUgVAGgMmwUMCN1ESAFEGQjxRW0KBW0SUQgGLoWsEBY
VCg0MCkHsE8CVAewVUxMIFBSAElNQVJZIEtFfFksFbQXVBj/GgcbVWPpFKBlZwWweRxKD0AdL3xx
dQBwBUAcLB9/CoBz6wGQACBwBRBjFDAhXx2JtmQIcBSgaQIgHEoyGfBtHT5hEsAlwl8cBSZ0NXsk
fyXAdBcRHC0pTyfnZDseQRixRBaiGLIdTWVimGF5YheQCsBlYRiyME1FTU8aBxW0KTv5FbpUaBRR
BQAv0B5QBCBfL+ABkRcRAhAFwHQUACDnF1IUcCpwaCAPQBVgCJAQbGRzLhiwSG93/mUVEAXAFNAj
EAMQAyAU89QyICNgbxcBbTUwFbTuMRnwMkAUMFAFEADAHpHMS2UeoBRRbm8FQBEhzzMgFVAn8Dmx
bnUG0ASQ/iwT8DWAMoADkTXxOYIyUfY/BgA6sHU1EBTBOmA0Af0LgGcVMQeAO5E84QuANtCzC2Aj
kW9mHKgU0HQIgescEDy0QTnxTjpDPHA58KszwRShIAlwdAhwbj9R/wSQA2AREDdlFbQmwRTQOvH6
JwVAZztjFDAs2zTjOaJqdwWwazVBST5QFNBhhmRFMTPhREVGQRpgdRowRB5BKBnwObEz0lP+URqA
IxEeUAeAINEU0EOip0HPMiIAcGtzG1VSDeAWaBW0EeEATEAAAAsAAYAIIAYAAAAAAMAAAAAAAABG
AAAAAAOFAAAAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAeACCAGAAAAAADA
AAAAAAAARgAAAABShQAAJ2oBAB4ACYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADku
MAAeAAqACCAGAAAAAADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAAHgALgAggBgAAAAAAwAAA
AAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4ADIAIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAA
AQAAAAAAAAALAA2ACCAGAAAAAADAAAAAAAAARgAAAACChQAAAQAAAAsAOoAIIAYAAAAAAMAAAAAA
AABGAAAAAA6FAAAAAAAAAwA8gAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADAD2ACCAGAAAA
AADAAAAAAAAARgAAAAAYhQAAAAAAAAsAW4AIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAAAwBc
gAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAACAfgPAQAAABAAAADWkNfvprMERo9oNq5Jsk9Z
AgH6DwEAAAAQAAAA1pDX76azBEaPaDauSbJPWQIB+w8BAAAAnwAAAAAAAAA4obsQBeUQGqG7CAAr
KlbCAABQU1RQUlguRExMAAAAAAAAAABOSVRB+b+4AQCqADfZbgAAAEQ6XERvY3VtZW50cyBhbmQg
U2V0dGluZ3NcQWRtaW5pc3RyYXRvclxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1p
Y3Jvc29mdFxPdXRsb29rXG91dGxvb2sucHN0AAADAP4PBQAAAAMADTT9NwAAAgF/AAEAAAAyAAAA
PEFFRUdJUEdJT0FET0pPRk5PSk9LTUVEUENCQUEuaWJ0b2FkQHB1bmthc3MuY29tPgAAAAMABhBk
gH7wAwAHED0CAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABlAAAAT0tIRVJFSVNXSEFUSUhBVkVT
T0ZBUjpDUkVBVEVUQUJMRSNVU0VSSUQjKElEVEVYVCg0MClOT1ROVUxMUFJJTUFSWUtFWSxVU0VS
SURURVhUKDQwKU5PVE5VTEwsQ0FURUdPUgAAAAB3lQ==
------=_NextPart_000_0000_01C0458B.5EE2DAB0--
----------------------------------------------------------------------------
--------------------
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]
------------------------------------------------------------------------------------------------
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]
