Hi!

If New_PriceA is parameter - use following statement.

Update Products Set PriceA=?New_PriceA Where ?New_PriceA>0

In another case "Column unknown" error will be produced (what is true)
if in table Products field New_PriceA not present.

WBR,Dmitry Beloshistov AKA [-=BDS=-]
-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On
Behalf Of Gordon Hamm
Sent: Tuesday, May 06, 2008 12:42 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Why doesnt this statement work?

Hi,

Is there any reason that this statement might have worked fine in
Firebird 1.5 and Not in 2.0 ??

Update Products Set PriceA=New_PriceA Where New_PriceA > 0

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