You need to unprepare them as well as make sure the connection is not
caching statement handles.

Regards,
Jason

----- Original Message -----
From: "bamber12001" <Gary@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, December 03, 2009 4:46 AM
Subject: [IBO] 'Freeing' stored procedures to allow them to be updated?


> Hi all,
>
> I have a few stored procedures (TIB_StoredProc) that return results that
> are used in reports.
>
> As long as no-one is running my application I am able to alter the
> procedures and save the changes with no problems (as expected).
>
> If someone has run a report which calls the procedure, I am unable to save
> any changes (I'm using IBExpert to make the changes) until they close the
> application completely.
>
> Are there any commands in IBO that 'free up' the stored procedure once
> it's been run to allow me to make and save changes on the server?
>
> I've tried things like sp.FreeServerResources and sp.UnPrepare but I'm not
> sure what the likely options are for what I'm trying to do as I don't know
> the proper name for it!
>
> Thanks,
>
> Bamber.