| Subject | Re: [firebird-support] Strange SELECT FIRST 1 |
|---|---|
| Author | Lucas Franzen |
| Post date | 2012-09-12T11:21:40Z |
Am 12.09.2012 13:13, schrieb Mr. John:
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.
> Hi masotti ,thanks for your answer,I always thought in this case whenYes.
> select doesn't return a record,these variables are set to NULL,that I
> was wrong ?
>
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.