Thanks all for your help,I'll review my code to fix that


________________________________
From: Lucas Franzen <luc@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, September 12, 2012 2:21 PM
Subject: Re: [firebird-support] Strange SELECT FIRST 1


 


Am 12.09.2012 13:13, schrieb Mr. John:

> Hi masotti ,thanks for your answer,I always thought in this case when
> select doesn't return a record,these variables are set to NULL,that I
> was wrong ?
>

Yes.

Null is an unknown value, whereas returning no record is not unknown,
it's just nothing.
So FB won't assign unknown to nothing.

As MM said:

When no record is returned the current value won't be neither touched
nor changed.
You have to do this on your own by assigning values to variables within
a loop.




[Non-text portions of this message have been removed]