Subject Re: Select + Update in a single SPROC?
Author hartertobak
Well, it is happening - what can I tell you?
I tried "else" as well, which makes the whole thing more readable, and
even tried changing the conditions (so update fires first instead of
insert), but no changes.

I´m not doing more than what I´ve posted.
Wow, starting with firebird is not as easy as I thought it would be.

best regards

> That's cannot be, unless you're modifying GETID in the first
> BEGIN .. END block that does the insert.
>
> Either way, why not use ELSE instead of IF (getid IS NOT NULL)