Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Sep 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Can anyone help whats wrong with the Syntax of my UPDATE system

    sql4="UPDATE Recycle SET Status='S', UserTaken=NULL ,Date=NULL ,Time=NULL ,Employer=NULL Where RefNO= '" & Ref & "'"

    Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

    Trying to Change Status fill to S
    and the others to a null or empty value

    Thanks For Reading

  • #2
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    Date and Time are probably reserved words, try putting squar brackets around them:
    Code:
    sql4="UPDATE Recycle SET Status='S', UserTaken=NULL ,[Date]=NULL ,[Time]=NULL ,Employer=NULL Where RefNO= '" & Ref & "'"


  •  

    Posting Permissions

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