| Subject | Empty Result Set / NULL handing |
|---|---|
| Author | slalom91 |
| Post date | 2007-04-10T21:25:45Z |
I had a stored procedure similar to the following:
----
Select value from table where id = someidnumber into :variable;
If (variable is null) then
result = 'EOF'
else
result = variable;
----
In FB 1.5 this was working when the result set was empty. However,
with FB 2.0.1 it is not.
Do I need to modify my syntax to be more compatible with FB 2.0.1? Is
this a documented adjustment to FB 2?
----
Select value from table where id = someidnumber into :variable;
If (variable is null) then
result = 'EOF'
else
result = variable;
----
In FB 1.5 this was working when the result set was empty. However,
with FB 2.0.1 it is not.
Do I need to modify my syntax to be more compatible with FB 2.0.1? Is
this a documented adjustment to FB 2?