SQL update not working with Access 97

[shef015]

my update statement refuses to work for some reason. I have no clue why it doesn't work. I am connected to an Access 97 database. I delete the records in OrdersDetail(a child table to Orders) before running the update. here is my code, any help would be great


order = "Update ORDERS SET Payment = '" & oPay & "'" & _
" AND TotalAmount = " & oTotal & " Where OrderID = " & oId & ""
MsgBox (order)
Set rs_updateOrder = conn.Execute(order)

 

[MarkSweetland]

The AND does not belong. The proper T-SQL syntax would be:

UPDATE ORDERS
SET Payment = <something>, TotalAmount=<something>
WHERE OrderID = <orderID>

Your statement revised:

Order = &quot;UPDATE ORDERS &quot; & _
&quot; SET Payment = '&quot; & oPay & &quot;', &quot; & _
&quot; TotalAmount = &quot; & oTotal & &quot; &quot; & _
&quot;WHERE OrderID = &quot; & oId & &quot;&quot;



Mark

 

[balajees]

Hi

The problem is that rs_updateOrder expects a recordset from conn.Execute statement .
Just do
conn.Execute order

Balajee

 

[shef015]

ok thanks for the help