Re: Syntax error in UPDATE statement.

From: Bob Lehmann (nospam_at_dontbotherme.zzz)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 06:41:52 -0700

desc is a reserved word. Name your column something else or enclose it in
square brackets [desc].

Bob Lehmann

"Ian Hills" <ian@sussexsoftware.co.uk> wrote in message
news:41bf589d$0$27587$afc38c87@news.easynet.co.uk...
> When I click OK in Database Editor after doing an Edit, I get this
message -
>
> Database Results Error
> Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
> UPDATE statement.
> Number: -2147217900 (0x80040E14)
> Source: Microsoft OLE DB Provider for ODBC Drivers
>
>
>
> And back in FP, I do a "verify" and get this -
>
>
>
> Server error: Unable to retrieve schema information from the query:
>
> UPDATE diary SET eventday = '1' , eventmonth = '2' , eventyear = '3' ,
> caption = '4' , desc = '5' WHERE (id = 6)
>
> against a database using the connection string
>
> DRIVER={Microsoft Access Driver
> (*.mdb)};DBQ=URL=fpdb/db1.mdb;UID=Administrator;PWD=secret.
>
> The following error message comes from the database driver software; it
may
> appear in a different language depending on how the driver is configured.
> -------------------------------------------------------
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE
statement.
>
> Source: Microsoft OLE DB Provider for ODBC Drivers
> Number: -2147217900 (0x80040e14)
>
> UPDATE diary SET eventday = '::eventday::' , eventmonth = '::eventmonth::'
,
> eventyear = '::eventyear::' , caption = '::caption::' , desc = '::desc::'
> WHERE (id = ::id::)
>
>
>
> Can anyone please tell me why this is happening? My Database Editor for
> another table
> (using the same connection) works fine. Am I only allowed 1 table per
> connection?
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.784 / Virus Database: 530 - Release Date: 27/10/2004
>
>

Relevant Pages