I'm sorry you first asked if it compiles, and it does when it commits but
the changes to metadata are not visible to until all connections have been
dropped. It's a protection mechanism. You can't have users happily going
about their business against your metadata then suddenly in the middle of
what might be a lengthy transaction - you jump in and change the metadata
from under them... the data they are transacting with or inputting may be
invalid half way thru their work. You wouldn't like that would you?
Alan

-----Original Message-----
From: Robert Razniewski [mailto:gustaf@...]
Sent: Tuesday, 4 March 2003 10:44 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] stored procs recompilation

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, March 04, 2003 12:34 PM
Subject: RE: [ib-support] stored procs recompilation


> you'll have to disconnect and reconnect to have the update execute
correctly
> for you trying it. Have you done this?
>

No, I did not. In fact - it works :-) Thanks, Alan.
But, what does it mean: ddl commit wil be executed by disconnect?

rr




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/