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



What I should further clarify is that the two variables I am working with
are Alpha & I am not sure of the dreaded quotes & how many?

I also said the variable goes on both sides of the BETWEEN & that obviously
is not correct.

Here are the actual statements from my query that I wish to substitute with
variables from a prompt screen.

<snip - Part of my QM/400 query)

AND (LWHS  BETWEEN '  '   AND '99')           
AND (LCARR  BETWEEN '      '   AND '999999'))
<snip>

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

-----Original Message-----
From: Dennis Munro [mailto:DMunro@badgerminingcorp.com]
Sent: Tuesday, May 08, 2001 1:31 PM
To: Midrange List (E-mail)
Subject: QM Question

V4R5M0 with latest cum & group ptf's in house but not yet applied.

I have a CL program that has a DSPF that prompts for 5 variables & a QM/400
query.  What has me struggling now is how do I pass in a variable from the
display file that contains *ALL to the query.  One thought was to do a
BETWEEN.  When *ALL is entered on the prompt screen, I substitute "  " &
"99" & when I have anything else, it goes on both sides of the BETWEEN.
Seems clean & easy enough to understand.

I'm wondering if someone else has a better way to do the *ALL & individual
value being passed in to a QM/400 query running in a CL program or will *ALL
work & I don't know how to make it work?

Looked through the two QM/400 manuals I found & I found nothing or maybe I
didn't know what to search on?  I tried the archives a few minutes ago & I
was not able to get to the home page but I will try there later in the day.

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-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.