|
No this will not work. The definition should be made as follows: OPNQRYF QRYSLT('VENDOR *EQ (%RANGE((' *CAT &XFROM *CAT ')(' *CAT &XTO *CAT '))' ) If VENDOR is a numeric field then the actual value of the variable should be a numeric value but defined as a *CHAR type in CL. Venkat Sreenivasan Metamor Worldwide "keshava narasimha" <anandthirta@hotmail.com> on 08/17/99 10:40:51 AM Please respond to RPG400-L@midrange.com To: RPG400-L@midrange.com cc: (bcc: Venkat Sreenivasan/IT/MIA/RCL) Subject: opnqryf Hi ! This could be a very simple question to most of you . Is this the right way to define the built-in fn.%RANGE in the OPNQRYF? Eg.OPNQRYF QRYSLT('VENDOR *EQ (%RANGE((&XFROM) ( &XTO))') VENDOR is a database file field XFROM (5,0) & XTO (5,0) are the screen fields. The query doesn't seem to be running. I tried with *GE & *LE also but I was left with run time errors. Can I get help!! Thanks in advance . kESHAV ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com +--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +--- +--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.