I would suggest to check if isMon null or not?

Regards

Sandeep

On Mon, 2002-10-14 at 16:58, Helen Borrie wrote:
> At 03:42 AM 14-10-02 +0000, you wrote:
> >Hi Helen, thanks for your suggestion.
> >
> >Yes, the field is constrained to upper case, but I tried your
> >suggestion anyway, to no avail.
> >
> >Is my code OK though?
> >
> >SELECT MONITOR FROM STOCK
> >WHERE STK_ID = :S_ID
> >INTO isMon;
> >
> >This *should* put the value of 'monitor' into my CHAR(1) var, isMon
> >shouldn't it?
>
> Yup. If you haven't already, try this query out in a client query tool
> that shows you a result set:
>
> SELECT MONITOR FROM STOCK
> WHERE STK_ID = <the constant value>
>
> But I guess you already tried this. I can't see anything in your SP which
> would cause its results to differ from what you see in an interactive query.
>
> Are you sure the S_ID parameter is being passed correctly? Is it for
> example a case-sensitive string that is getting mangled by your application
> code?
>
> heLen
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>