it's not that easy to give you a test case or I have to give you the
database and even backuped it's also about 6MB.

"Helen Borrie" <helebor@...> schreef in bericht
news:5.1.0.14.2.20030414215247.0354f7c0@......

> 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
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>