Richard,

One of the programs in the WyattERP project, that is freely available, builds a
CL variable for your QRYSLT value.  This reduces your need to count quote marks
and the frustration of debugging these trivial kind of things.

The program to use is $QRYSLT2 which is a component of a RUNQRY record selection
act alike.

To see how it is used, connect to the netshare400 site at 63.167.147.10 and log
on as wyatterp (pw: wyatterp) and chose option 10 (WRKMBRPDM) to allow you
access to the source library.  Position to, and look at, ITEMLST1 starting at
line 114 which does a series of comparing parameters to blank or zero, and if
not, does a call to $QRYSLT2 to build the QRYSLT string.

hth

Richard Reeve wrote:
>
> No, I had a few mis-placed quotes. The correct qryslt
> statement looks like this;
>
>  QRYSLT('LSTCHG *GE ' *CAT &BEGUPD *CAT +
>  ' *AND LSTCHG *LE ' *CAT &ENDUPD *CAT +
>  ' *AND RECTYP = "M" ')
>
> Thanks for the speedy responses.  Boy, this list sure
> does make life easier.
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.