Thanks all for your help,I'll review my code to fix that
________________________________ From: Lucas Franzen <l...@frred.de> 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]