Syntax error in UPDATE statement.

From: Ian Hills (ian_at_sussexsoftware.co.uk)
Date: 12/14/04

  • Next message: Thomas A. Rowe: "Re: Syntax error in UPDATE statement." 
    Date: Tue, 14 Dec 2004 21:18:24 -0000

    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
  • Next message: Thomas A. Rowe: "Re: Syntax error in UPDATE statement."

    Relevant Pages

    • Re: Syntax error in UPDATE statement.
      ... the "syntax error" indicates that there is something wrong with the ... > Database Results Error ... Microsoft OLE DB Provider for ODBC Drivers ... > The following error message comes from the database driver software; ...
      (microsoft.public.frontpage.client)
    • Syntax error in UPDATE statement.
      ... When I click OK in Database Editor after doing an Edit, ... [ODBC Microsoft Access Driver] Syntax error in ... DRIVER={Microsoft Access Driver ... Syntax error in UPDATE statement. ...
      (microsoft.public.frontpage.client)
    • Trying to create a database in a MS Access DB via JDBC drivers
      ... I am trying to create a database in a MS Access DB via JDBC drivers. ... Syntax error in CREATE TABLE statement. ... Driver] Syntax error in CREATE TABLE statement ...
      (comp.lang.java.databases)
    • Trying to create a database in a MS Access DB via JDBC drivers
      ... I am trying to create a database in a MS Access DB via JDBC drivers. ... Syntax error in CREATE TABLE statement. ... Driver] Syntax error in CREATE TABLE statement ...
      (comp.lang.java.programmer)
    • Database Results: No read permissions
      ... When using the Database Results Wizard I can access the ... database connection, but then I'm stopped by the ... 'DRIVER={Microsoft Access Driver ... [ODBC Microsoft Access Driver] ...
      (microsoft.public.frontpage.programming)
    Loading