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]

Reply via email to