Subject | Re: Select + Update in a single SPROC? |
---|---|
Author | hartertobak |
Post date | 2007-11-23T13:52:44Z |
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
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)