On Mon, 25 Aug 2003 18:55:31 +0000 (UTC), Milan Babuskov wrote:

> Just to add a few things:
> ...
>
> This second select is extra. You already know what value is there.
> So here's my idea of it:
>
> SET TERM !!
> CREATE PROCEDURE GETPAYNUM RETURNS (hightn INTEGER) AS
> BEGIN
> SELECT LU_RATE FROM LUTABLE WHERE LU_FIELD='PYNUM' INTO :hightn;
> IF (LU_RATE IS NULL) THEN

What LU_RATE? Shouldn't this be
if (hightn is Null) then

Also: initialize hightn (in case the select won't return any record)

> ...

--
Aage J.