Hi,

At May 21, 2003, 14:26, Fernando Buitrago (Listas y Foros) wrote:

> Note:
> In las days, i´d trie to delete a table, and FireBird say that
> "you can drop because CLIENTES_S exists.....CLIENTES_S was a deleted
> StoredProcedure....

As long as there's a connection to the database, the stored procedure
will not be dropped. Unless, the connection that dropped the stored
procedure is the only connection to the database. If you still can't
drop the table, then try restarting Firebird, to see if the stored
procedure is effectively dropped.

> FireBird bug?, Maybe. Anyway, FireBird Interbase is enogth to me, in
> spite of the little bugs.

The behavior is as designed. It would be nice if a new option existed
to recompile or effectively drop a stored procedure, when no
connection is using the stored procedure. But, I suppose this would be
a feature request for FB 2.0.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)