AFAIK some changes into SP or Trigger is not applied when there is some
active connection to the database. I always check if some application (or
for example TDatabase component from Delphi) is connected. After
reconnecting all should be OK.
Ales

> -----Original Message-----
> From: Ben Johnson [mailto:ben_johns@...]
> Sent: Friday, July 19, 2002 1:36 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] strange behaviour of exception in SP
>
>
> Hi,
>
> An exception in a stored procedure (which I called from a
> trigger)
> activated even after I removed it from the code. I re-compiled it
> and
> saved using IBExpert (personal) and Marathon, it still got
> activated.
> I even removed the exception from the database, this also did not
> work.
> Then I took a backup of the db and restored, this worked!
>
> I am using Firebird 1 on W2K.
>
> Thank you.
>
> Ben
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Free $5 Love Reading
> Risk Free!
> http://us.click.yahoo.com/wlyPtD/PfREAA/Ey.GAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> 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/