That relified me from a lot of headheace... thanks..

brgds,
sohail

--- In ib-support@y..., "Martijn Tonies" <m.tonies@u...> wrote:
> Hi,
>
> (comments below)
>
> > I am sorry Regina, I tried to insert the if statement as you
> > recomomended in your example, but I got the following error in
> > interbase:
> > Dynamic SQL Error
> > SQL error code = -206
> > Column unknown
> >
> > Strange enough though that if I discard the if statement there is
no
> > problem. I had also created the exception itself before the
stored
> > procedure.
> >
> > brgds,
> > sohail
> >
> >
> > --- In ib-support@y..., "Regina Phandu" <regina@3...> wrote:
> > > You have to create exception first, like this:
> > >
> > > create exception sanger 'No more beds';
> > > commit;
> > >
> > > then inside the procedure you can called it: exception sanger
> > >
> > > SET TERM ^ ;
> > > CREATE PROCEDURE SANGPLATSER
> > > (AVDID INTEGER, KON CHAR(1))
> > > RETURNS
> > > (TOTAL_SANGER CHAR(10))
> > > AS
> > > BEGIN
> > > SELECT COUNT(PERSNR) FROM VY_SANGPLATSER
> > > WHERE
> > > AVDID = :AVDID
> > > AND
> > > KON = :KON
> > > INTO :TOTAL_SANGER;
> > > if (persnr > 20) then exception sanger;
>
> persnr is not defined here - the value is in the TOTAL_SANGER
variable.
>
> So, IF (TOTAL_SANGER > 20)
> might work...
>
> I guess you could figure that out yourself...
>
>
> With regards,
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase
> http://www.upscene.com
>
> Firebird Workbench - the developer tool for Firebird
> http://www.upscene.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."