#1
  1. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Aug 2008
    Location
    USA
    Posts
    1,606
    Rep Power
    347

    syntax error in update statement


    facing issue on update statement, I'm using vb.net


    update a set amount=112,paidstatus='No' ,paiddate='11/16/2013',action='No', addedon= Now() where id=1

    error as : syntax error in update statement

    find attached table structure
    id autonumber
    name text
    exp text
    amt number
    dt date/time
    status text
    pdt date/time
    action text
    added date/time



    Thanks for help
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree

    Jquery Shake Effect ,
    Andriod KitKat


    Thank You,
    KiranK
  2. #2
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Aug 2008
    Location
    USA
    Posts
    1,606
    Rep Power
    347
    Hi,

    i m using msaccess database , and when i tried to run the same script from access it works.

    i had tried the below scripts in code and it works
    update a set amount=112 where id=1
    even this as well update a set paiddate='11/16/2013' where id=1

    but when i tried to put the multiple fields with , then it show update error.

Similar Threads

  1. syntax error in update statement
    By hithere in forum ASP Development
    Replies: 3
    Last Post: December 23rd, 2004, 01:25 AM
  2. Syntax error in UPDATE statement
    By tengoku in forum ASP Development
    Replies: 2
    Last Post: November 3rd, 2004, 12:12 AM
  3. Syntax error in Update statement in VBA
    By musicfanz in forum Microsoft Access Help
    Replies: 4
    Last Post: March 19th, 2004, 10:59 AM
  4. Syntax error in UPDATE statement
    By jega in forum ASP Development
    Replies: 3
    Last Post: March 10th, 2004, 08:26 AM
  5. Syntax error in UPDATE statement
    By Steve Schofield in forum SQL Development
    Replies: 1
    Last Post: May 20th, 2001, 06:23 PM

IMN logo majestic logo threadwatch logo seochat tools logo