× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: opnqryf
  • From: "Venkat Sreenivasan" <vsreeniv@xxxxxxxx>
  • Date: Tue, 17 Aug 1999 12:02:45 -0400



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 thread ...


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

This mailing list archive is Copyright 1997-2024 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.