Re: OleDbException: Syntax error in UPDATE statement

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Miha Markic [MVP C#] (miha)
Date: 07/12/04 

Date: Mon, 12 Jul 2004 18:31:26 +0200

Enclose it in square brackets. 

-- 
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com
"VB Programmer" <Dont*NoSpam-Please*@jEmail.com> wrote in message
news:%23dbmlwCaEHA.2892@TK2MSFTNGP10.phx.gbl...
> Apparently it didn't like the field 'password'.  I guess it's reserved?!
>
> "VB Programmer" <Dont*NoSpam-Please*@jEmail.com> wrote in message
> news:O3NOGrCaEHA.1768@TK2MSFTNGP10.phx.gbl...
> > I get this error when running an UPDATE command against my db.  (I paste
> the
> > SQL in Access and it works fine!)
> >
> > System.Data.OleDb.OleDbException: Syntax error in UPDATE statement. at
> > System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
> at
> >
>
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
> > dbParams, Object& executeResult) at
> > System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
> at
> > System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
> > Object& executeResult) at
> > System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
> > behavior, String method) at
> System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
> > at ExecuCare.AdminSubscriberManagement.cmdSave_Click(Object sender,
> > EventArgs e) in
> > c:\inetpub\wwwroot\EC\Secured\AdminCustomerManagement.aspx.vb:line 339
> >
> > Here's the SQL:
> > UPDATE Customers SET FirstName = 'Robert', LastName = 'Smith', Address =
> '',
> > BusinessPhone = '', CellPhone = '', City = '', FaxPhone = '', HomePhone
=
> > '', Notes = '', Password = 'ecadmin', State = '', UserName = 'admin',
Zip
> =
> > '', IsAdmin = True WHERE CustomerId = 1;
> >
> > Any ideas?
> > Thanks.
> >
> >
>
>

Relevant Pages

  • OleDbException: Syntax error in UPDATE statement
    ... I get this error when running an UPDATE command against my db. ... Syntax error in UPDATE statement. ... System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at ... Here's the SQL: ...
    (microsoft.public.dotnet.framework.adonet)
  • Help: SQL syntax error???
    ... When I run an SQL statement with ADO.NET it gives me this error: ... Syntax error in INSERT INTO statement. ... dbParams, Object& executeResult) ... When I copy/paste the SQL directly into an Access query and run it it runs ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OleDbException: Syntax error in UPDATE statement
    ... > I get this error when running an UPDATE command against my db. ... > System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) ... > at ExecuCare.AdminSubscriberManagement.cmdSave_Click(Object sender, ... > Here's the SQL: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: NULL problem with Created table
    ... an empty string. ... From vb.net I create a table with columns with this SQL: ... but the Update command fail with this error "Syntax error in UPDATE ...
    (microsoft.public.access.queries)
  • Re: Syntax error in INSERT INTO statement.
    ... You need to enclose Access reserved keywords in square brackets: ... Syntax error in INSERT INTO statement. ... dbParams, Object& executeResult) +267 ... eventArgument) +7 ...
    (microsoft.public.dotnet.framework.adonet)