At 01:46 PM 14/04/2003 +0200, you wrote:

>The problem is that when the sql statement (eg.)
> SELECT Stock FROM RESM_STOCK WHERE ItemIdx = :ItemIdx INTO :StockQty;
>is executed in the procedure and there is no result for the current ItemIdx,
>it containts the result of the previous select where ther was a record for
>Itemidx.
>eg
> Select ... ItemIdx = 5 -> result 10
> Select ... itemidx = 1 -> (no record for it) return also 10
>
>I must say that I only have this problem when using stored procedures. In
>this case the procedure also manipulated a lot of tables.

This was the case in IB 5.x and IB 6. In IB 5.x, the safety net was to
ensure that each iteration of the loop began by initialising all of the
variables...

If you are seeing this in Firebird (where it is supposed to have been fixed
so that the engine re-initialises the variables) then we certainly would
appreciate a test case.

heLen