|Subject||Re: [firebird-support] Re: Select + Update in a single SPROC?|
>Well, it is happening - what can I tell you?Actually, it is. The logic of an IF .. THEN statement is the same
>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.
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.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!
> 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 http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
Yahoo! Groups Links