Subject Re: [firebird-support] Re: Select + Update in a single SPROC?
Author Martijn Tonies
>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.

Actually, it is. The logic of an IF .. THEN statement is the same

However, what CAN be happening, is that the server is caching
the compiled version of your procedure, this happens, for example,
when there are other people using it (other connections, that is).

Make sure you're either the only one connected or that you disconnect
every connection to make sure the server is using the most recent
version of your procedure.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!

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)


Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links