Hi Johan,

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

Retrieve a NULL where?

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

You mean, if this SELECT doesn't return any rows? 'Cause then STOCKQTY will
stay empty (null).

> 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

Better explain what you mean :)


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com