I know little jet, but it looks like other SQLs... Are you missing a comma
right after counter?
> -----Original Message-----
> From: CF-Talk [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 10, 2000 3:48 PM
> To: CF-Talk
> Subject: What is wrong with the create table statement for Jet SQL ?
>
>
> 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]
------------------------------------------------------------------------------------------------
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]