I tried the same with IB_SQL 3.5Ai and it doesn't
display this behavior.

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, December 01, 2006 10:33 PM
Subject: Re: [IBO] IB_SQL_IBO_4_7_Beta11 problem


> At 03:48 PM 2/12/2006, you wrote:
>
>>IB_SQL_IBO_4_7_Beta11.zip
>>
>>Everytime I update a procedure and run a Cursor SQL to test it,
>>it says procedure in use when I repeat the process while building
>>the same procedure. Have to disconnect and reconnect to continue
>
> That's inherent in the DB engine. Once you run a SP it is
> cached. If you then alter the procedure, you will have to reset the
> cache before being able to run the new version. (Reset the cache =
> put the db offline and then online for Superserver, simply log off
> and on again for Classic.)
>
> Helen
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>