Subject Re: [firebird-support] Stored procedure dependency.
Author Martijn Tonies
Hi Gianni,

> I'm try to alter/drop a stored procedure but every time I try I get the
> message :
> "Error at line 1 - unsuccessful metadata update
> cannot delete
> there are 1 dependencies"
> I have removed ALL stored procedures that call this procedure, looked
> everywhere in the metadata and there are NO places where this procedure
> and coloumns are mentioned...

Did you ever had such a column? Or do you have the idea that
this specific name misses the first two characters?

If the latter, you've hit one of the "dependency bugs". This should
be fixed in newer versions of Firebird though.

If this is the case, you can delete those specific records from
RDB$DEPENDENCIES yourself. - but, be careful!!!

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions