Hi,

One of my stored procedures is manipulating a lot of tables and need in a
loop the data that is writen to the db in this same loop.
The problem I have is that the variables aren't update always when I need to
retrive a null from the database.
The current sollution I have is to set the var to 0 and then it works. Here
follows an example
StockQty = 0;
StockAdaptionQty = 0;
SELECT Stock FROM RESM_STOCK WHERE ItemIdx = :ItemIdx INTO
:StockQty;
SELECT Quantity FROM RESM_STOCK_ADAPTION_DETAILS WHERE
ItemIdx = :ItemIdx AND AdaptionIdx =:AdaptionIdx INTO :StockAdaptionQty;

so if i dont set StockQty and StockAdaptionQty to 0 then I don't get the
correct data.

Mayby this is a bug in FB or is there any other explination for it.


Regards


Johan

PS: if needed I can send the complete proc source