Subject Re: [firebird-support] INTO clause is execute before SELECT
Author Helen Borrie
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.