Problem with update statement again .
Asprunner 7.0 build 9948.
The following statement syntax okay in event software .
Server error ; see below. Can't see anything wrong with this????
sql="update Customers set posbal= " & values("poscost") & " " & values("posqty") & " Where Customer ID = " & values("fldcut_num") & " "
All Numeric Fields.
Error Message :
Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'Customer ID = 700056699'.
/cdi/output3/include/dal.asp, line 230
On Print Returns:
update Customers set posbal= 2 15 Where Customer ID = 700056699
Which Seems Perfect????????????
Any Ideas .