Gladly help testing, keeps me busy :)

----- Original Message -----
From: "Jason Wharton" <supportlist@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, December 02, 2006 12:59 PM
Subject: RE: [IBO] IB_SQL_IBO_4_7_Beta11 problem


> In the past I recall confronting this problem and I did some stuff to try
> and avoid it. This largely depends on how fussy the engine wants to be,
> but
> there are things I can do in IBO to minimize the interference. In IBO
> there
> are events which give notification when a DDL command has been executed.
> I
> recently changed the order in which these event notifications take place
> which could have upset the order of things.
>
> I'll revert that change because it wasn't for such a critical concern and
> it
> may have been the cause of this. Then, I'll want you to test your
> situation
> again and see if that remedies it. We could also be facing another issue
> of
> some kind. Doing a disconnect from the database isn't necessary, but it
> is
> necessary to deallocate the statement handle. If there are cached
> statement
> handles then its possible your ability to make DDL changes in the database
> could be hampered. However, I thought I made IBO automatically purge the
> statement handle cache when DDL is executed.
>
> If I look things over carefully I will likely get things back to normal
> again.
>
> Jason Wharton
>
>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
>> Behalf Of Helen Borrie
>> Sent: Friday, December 01, 2006 10:34 PM
>> To: IBObjects@yahoogroups.com
>> 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
>
>
>