Hello Milan,

> > 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.

No.

> > 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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com