What the hell is wrong with this create table statement (Jet SQL for
MS-Access).
I want to build it via CF.
<cfquery name="qry_delete"
datasource="Mail_Q"
dbtype="ODBC">
CREATE TABLE EventLog
(
ID COUNTER
CONSTRAINT ID PRIMARY KEY,
Domain TEXT 128,
IP TEXT 40,
Action TEXT 10,
xDate DATE 8,
Info TEXT 255
)
</cfquery>
I get a syntax error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntaxfehler in CREATE
TABLE-Anweisung.
Thank you.
Uwe
SD Solutions
Lange Zeile 27
85435 Erding
Fon: 08122/903791
Fax: 08122/903792
Mail: [EMAIL PROTECTED]
Web: www.sdsolutions.de
------------------------------------------------------------------------------------------------
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]
