Good News Everybody!
The new search engine is LIVE!
Please report any problems to david (at) midrange.com.
|
Hi Bob,The resulting value of the QRYSLT parm after all the concatenations are done has to include quotes around the &DIV and &BOOK values. Try
midrange.com
OPNQRYF FILE((DOR400/GLTRAN)) +
QRYSLT(' +
GTACCT *EQ %VALUES(3120 3140 3150 3170) *AND +
GTBDTE *EQ "' *CAT &BOOK *TCAT '" *AND +
GTSOUR *EQ %VALUES("BI" "AR") *AND +
' GTDIV *EQ "' *CAT &DIV '")') +
KEYFLD((GTREF))
OPNQRYF FILE((DOR400/GLTRAN)) +
QRYSLT(' +
GTACCT *EQ %VALUES(3120 3140 3150 3170) *AND +
GTBDTE *EQ "' *CAT &BOOK *TCAT '" *AND +
GTSOUR *EQ %VALUES("BI" "AR") *AND +
GTDIV *EQ "' *CAT &DIV *TCAT '")') +
KEYFLD((GTREF))
Another note - *CAT, *BCAT, *TCAT are all concatenation operators, and only
work on character constants or variables. And you can concatenate two
variables, not just a variable + a constant.
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2026 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.
