There are times when you don't want your source code to escape into the wild. But in the rush and tumble of deploying an application to a client, short cuts can (and usually are) taken which can result in your precious source code leaving it's comfortable home in your PC.

So then, your left with the problem of removing the source from a runtime system. Not an easy task. I know, I've been there, done that.

That's why I ended up writing a Remove Source stored procedure which can be run from a runtime with just a few quick keystrokes.

The RGD_APPLICATION_REMOVE_SOURCE procedure will remove the following source items from a system (be it runtime or development).

OIWINS - OpenInsight form definitions.
OIEVENTS - Event source code.
OISTPROC - Stored procedure source code.
STPROCDBG - Stored procedure debug tables.
STPROCINS - Insert records.