Subject 'Freeing' stored procedures to allow them to be updated?
Author bamber12001
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.