I'm writing a program to update a database from a structure template.
I have a problem with a wiew which uses a selectable procedure.
The name of the wiew is MORTALIDAD and it uses a stored procedure.
If I execute the sentence:

select * from RDB$DEPENDENCIES
where
RDB$DEPENDENT_NAME='MORTALIDAD'

I don't get a row for the stored procedure that the view depends on, and if I execute the sentence:

select * from RDB$DEPENDENCIES
where
RDB$DEPENDENT_NAME='MORTALIDAD'
and RDB$DEPENDENT_TYPE=5

I get no rows at all.

Is it a bug? Am I doing something wrong? Are there another method to find out the dependencies between views and selectable procedures.

Thanks

Luis Miguel Molinero
Las Rozas - Madrid (SPAIN)