At 07:40 PM 30/11/2007, Milan Babuskov wrote:

>kokok_kokok wrote:
>> I use FB 2.0 and in a SP I get strange results. It really seems a FB bug:
>
>Or maybe a bug in your connectivity library.


>> select :acumunits + units,
>> (:acumunits*:acumprice+price*units)/(:acumunits+units)
>> from inventorytable
>> where inventoryid=:inventoryid
>> into :acumunits, :acumprice;
>
>Firebird doesn't use :paramname, it uses ? as a placeholder for
>parameters. It's your connectivity layer that translates :param to ?,
>and probably 'gets lost in translation' :).

Hmmm, the example given is PSQL, not DSQL, Milan.

Helen