Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    19

    Unanswered: Update multiple records

    I'm trying to update many records in a database with the following statement.
    Seams it isn't going to be as easy as...


    Update = "UPDATE vpo STATUS=PENDING WHERE STATUS=APPROVED"
    Conn.Execute( Update)


    I get this error..

    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
    [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
    line 9


    Line 9 is the update statement, any one have some easy other ways to do this?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    As the error indicates, the syntax of your SQL is wrong. I note you've posted update SQL on other threads with the correct syntax, so you may want to revisit that (hint: SET). I'd guess you're also going to need single quotes around PENDING and APPROVED.
    Paul

  3. #3
    Join Date
    Feb 2004
    Posts
    19
    Wow.. guess I'd been coding for too long, I can't believe I missed that.. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •