...

View Full Version : Can anyone help whats wrong with the Syntax of my UPDATE system



Viru5
09-30-2005, 01:27 AM
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 :(

Brandoe85
09-30-2005, 02:27 AM
Date and Time are probably reserved words, try putting squar brackets around them:


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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum