Have you checked your quotes? firebird can seem buggy in regards to
quotes (in reality i suspect it is working as designed and intended and
it was ibconsole actually introducing the program) but particularily in
stored procedures and views you can put a quote in the name and it will
appear as if you dont need the quote when dropping/using it but in
reality you do. try checking to make sure you didnt put a quote where
you shouldnt have.
James wrote:

> Hi Guys,
>
> Helen Borrie wrote:
>
> > At 09:28 AM 27/05/2004 +0800, you wrote:
> > >Hi guys
> > >
> > >I have a view where I want to drop it, but an error message appears
> > >saying it can't perform this action cause there is 1 dependencies.
> > >Using the IBExpert, I don't see any object that depends on that
> view? Is
> > >there something wrong?
> >
> > Why not just query the dependencies yourself?
> > Select * from rdb$dependencies
> > where rdb$depended_upon_name = 'MyView';
> >
> > /heLen
>
> Thanks for your reply Alexandre and Helen. I have try what you suggest
> and the result is null. What should I do next? Backup and Restore? What
> if it doesn't work?
>
> Helen am I right to say that the rdb$depended_upon_name is a typo error
> and it should be rdb$depended_on_name?
>
> Thanks
>
> james
>