Re: Syntax error in UPDATE statement.

From: Thomas A. Rowe (tarowe_at_mvps.org)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 16:29:14 -0500

This is not an issue dealing with your database connection, it is your actual update SQL statement.
Which version of FP are you using? 

-- 
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
"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

  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Re: ESQL/C documentation nightmare
    ... documentation about explicit and implicit connections. ... CONNECTION connection statements for new applications of Version 6.0 ... the SQL database statements (such as ...
    (comp.databases.informix)
  • Re: Communicating over the internet
    ... > That way you provide one manner in which to open the database, ... > can keep the connection open and then when someone wants to ... > server as the database and the soap dll connecting with a TCP socket. ... The name of the running program might help. ...
    (microsoft.public.vb.general.discussion)