Subject Re: [IBO] IB_SQL_IBO_4_7_Beta11 problem
Author Helen Borrie
At 03:48 PM 2/12/2006, you wrote:

>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.)