Re: HELP with SYNTAX!!!!!!!

Vic Millan wrote:

> Hello,
>
> I hope someone can correct my syntax with ths line of code:
>
> IF ('#LIPREPAY#' = 'CC' and '#PREPAYAMOUNT#' = select amount from
> prepayment where adno = '#ADNO#' and vno = 'Y')

This could work:

IF

   ( '#LIPREPAY#' = 'CC'
    AND '#PREPAYAMOUNT#' IN ( SELECT amount

                                                               FROM
prepayment
                                                            WHERE adno =
'#ADNO#'
                                                                 AND vno
= 'Y'
                                                           )

but maybe you should write an explicit Cursor...

til Received on Fri Sep 03 1999 - 14:17:22 CEST