Subject Re: [firebird-support] INTO clause is execute before SELECT
Author Martijn Tonies
Hello Milan,

> > I use FB 2.0 and in a SP I get strange results. It really seems a FB
> 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' :).

Did you read the first sentence saying "in a SP"?

> You should tell us what programing language and connectivity library you
> are using (for example: Delphi/IBX) to investigate this issue
> completely. I could still be a Firebird bug, but we can't tell for sure
> until we know what is the exact SQL that goes to the engine.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!