At 01:40 PM 27/11/2003 +0100, you wrote:

>Hi
>
>Firebird 1.0.3
>WIN 2000 P
>
>if i do
> select count(*) from rdb$procedures rp where rp.rdb$procedures =
>:oime_procedure
>then the result is correct
>
>if i do
> if (exists(select * from rdb$procedures rp where rp.rdb$procedures =
>:oime_procedure)) then ...
>the result is always true
>
>Is this ok ??

No. You should get an exception in the first case and the PSQL in the
second case should fail to compile. rdb$procedures doesn't have a column
called rdb$procedures.

Is your problem description correct?

heLen