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

>
>
> *Yahoo! Groups Sponsor*
> ADVERTISEMENT
> <http://rd.yahoo.com/SIG=129isj3um/M=295196.4901138.6071305.3001176/D=groups/S=1705115386:HM/EXP=1085719339/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com>
>
>
>
> ------------------------------------------------------------------------
> *Yahoo! Groups Links*
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>