Subject Re: Can SLCODE 100 be trapped in an SP?
Author Alexander V.Nevsky
Post date 2002-10-18T11:07:04Z
--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> ALexander, can you enlighten me?
> select exists?

Sorry, Alan, I was inaccurate. Of course I meant

If (Exists (Select ...)) then ...

instead of

Select Count(*) ... Into :MyVar;
if (MyVar>0) then ...

Best regards, Alexander V.Nevsky.