Continually Improving.... let us know how support@devdiamond.net Sign in | Sign up
home articles news blog forum  

 
 


 
Skip Navigation LinksHome > Forum > Error in UPDATE statement
 
Summary :

Views : 0
Published : Saturday, June 25, 2005
By
HyperLink



Hi,
   I get the following error:

Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.
/mixdb/genericdb/MixMatListVarSetUp2.asp, line 78

CODE:
strSQL3 = "UPDATE tblmixlistmaterials SET tblmixlistmaterials.PoundWeight ="& poundweight
strSQL3 = strSQL3 &", SET tblmixlistmaterials.GramWeight = "& gramweight
strSQL3= strSQL3 &"   WHERE tblmixlistmaterials.MixIng