I’ve old project in delphi 2010, DA 220.127.116.113. DB: MsSql 2005 Express.
I’ve procedure that will execute the update statement by IDASQLCommand in following order：
- update value_tbl SET VALUE = 300 WHERE id= 2
- update value_tbl SET VALUE = 600 WHERE VALUE = 200
I suppose the ID =2 row value is 300 as in the first statement already changed the value to 300.
However, I get the final result is ID=2 row, it change to 600 instead of 300.
I need commit the transaction first or any else to make the result exactly as my execution order.
Any suggestion on this case?