On Sun, Jul 15, 2012 at 6:35 PM, mariuszstefaniak <
mariuszstefaniak@...> wrote:

>
> I've strange problem. Sometimes (sometimes, because problem is quite
> irregular), after I altered procedure, firebird still runs unchanged
> (previous) version of my procedure. Procedure fired directly (by execute
> procedure) works like I want, but procedure triggered (by a trigger) works
> like before changing.
>

OK, summarizing - a procedure invoked from a trigger does not reflect
changes made to the procedure even though a direct invocation of the
procedure does reflect the change.

I thought, that this is a problem of session and cache, but after I tried

> (unsuccessfully) close any connection to firebird, restart firebird
> services and restart my computer I know, that the problem is elsewhere.
>

OK, rebooting the computer sho

> The only that helps, is recreating of trigger that triggers my procedure.
> After this operation, everything works as it should.
>
> My environment is:
> Win Xp pro x86 Sp3, FB 2.5.1.26351. Also I work with IB Expert Personal
> 2012.5.19.1 and Devart VCL components for Interbase - version 4.1.4.
>
> Does anyone observed these behaviour? Anyone know what should I do?
>
> regards
> Mario
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>

[Non-text portions of this message have been removed]