I have seen old versions of SPs run after making mods and compiling
successfully.
This is using Delphi and IB Expert.
What I've done is:
1. Whatever tool you're using to modifiy the SP, disconnect from the
database.
2. If the old version of the SP was running from w/in Delphi, make sure the
database component is not connected to the gdb.

This usually does it for me.
Never had a trigger never fire and never had the "Object in use" error (he
says knocking on wood).

Kevin

> -----Original Message-----
> From: Dmitry Yemanov [mailto:dimitr_ex@...]
> Sent: Tuesday, August 28, 2001 8:34 AM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Disappointed in Interbase (long)
>
>
> Louis,
>
> Just some experience with IB6-based complex HR system
> (development was done
> with QuickDesk & IB_WISQL).
>
> > We decided to stick to IB5.6 for now as it is certified,
> > and it will not require a migration to a new version of IB.
>
> Didn't have any problem migrating the database from IB5.6 to IB6
> dialect 1.
> And believe that even uncertified IB6 is more stable than certified IB5.
>
> > - Getting the 'Object in use' message. Then everybody has to
> > log off and we
> > have to do a backup & restore cycle to be able to use the
> > index/table/SP/whatever again
>
> Sometimes with FKs.
>
> > - Triggers not firing. Goodness knows why not.
>
> Never seen.
>
> > - SP not running correctly. We have had the following problem
> > that really
> > boggles the mind. We have also repeated this to make sure we
> > are not making
> > stupid mistakes. We compile a SP sucessfully. If we run it,
> > the old version
> > still runs. No matter how often we recompile the SP, it still runs a
> > previous version. Then we all log off, do a Backup & Restore
> > (B&R) and
> > viola! the problem disappears and the correct version of the
> > SP runs. We
> > change the SP & compile and same problem happens. And this on
> > the restored
> > DB! We had to resort to B&R after each SP update & compile
> > session. I can
> > assure you that this is no fun..!
>
> Never seen.
>
> > - Abnormal server terminations
>
> Periodically with IB6 beta. With the release of IB6 (and then
> Firebird) - no
> problems.
>
> Cheers,
> Dmitry
>
>
>
> 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/
>
>
>