Lauri Zoova wrote:

> Is this kind of usage of exist 'legal'?
> if (exists(select * from test_view r where r.rdb$relation_id >
> :v_month)) then begin

AFAIK, Yes. I use it in a few SPs myself.

> I'm having a problem with it in another SP. I tried to reproduce it in
> this SP, but this one works as expected.

Perhaps you should post that other SP here then ;)

--
Milan Babuskov
http://fbexport.sourceforge.net