Re: opnqryf

["Venkat Sreenivasan" <vsreeniv@xxxxxxxx>]

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
+---