Bill,
Thank you very much. Even though I've used
R:BASE for years I haven't used procedures before. The
help file on stored procedures explains everything except
how to drop them. So I found my own way via the
sys_procedures table. When I looked up the drop command
there it was. Thanks again.
On Wed, 20 Jun 2001 17:46:46
-0500 Bill Downall <[EMAIL PROTECTED]> wrote:
> On Wed, 20 Jun 2001 11:51:56 -0400, Bob Powell wrote:
>
> >Can anyone on this list serv give me a reason as to
> >why I shouldn't deleted procedures directly from the
> >sys_procedures table when I want to remove them?
>
> Well, for one, it is a lot easier to do:
>
> DROP PROCEDURE procedurename
>
> than it is to do:
>
> DELETE FROM SYS_PROC_COLS +
> WHERE SYS_PROC_ID = +
> (SELECT SYS_PROC_ID FROM SYS_PROCEDURES +
> WHERE SYS_PROC_NAME = 'procedurename')
>
> DELETE FROM SYS_PROCEDURES +
> WHERE SYS_PROC_NAME = 'procedurename'
>
> Bill
>
>
>
>
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]
