Hi, This Query used to work perfect with firebird 1.5, now it doesnt with 2.0. Even if the field "Amount" is Null...

Update Ord_Head set Ord_Head.Amount=:Amount
Where ord_Head.OrderNum=:OrderNum
and ord_Head.Amount <> :Amount


I added this code, so it wouldnt made a change, unless the amount is different
"and ord_Head.Amount <> :Amount"

If I remove that line, works perfect..

I thought that it would save resources, as this query is called often..


When it does the evaluation, it seems like it looks at the "Amount" as if the field has already been updated..
Weird..
Am I missing something?










[Non-text portions of this message have been removed]