Re: OPNQRYF Question

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

Yup. It is possible.  You have to do a join in the OPNQRYF command.  This
may require a new format map to be built even though you are only interested
in the output from the courses file.  (it's been so long since I've used
open query, I just don't remember if the qryslt parameter requires the
fields in the output or not.)  You join to the tablelookup with location =
id and your selection logic in the qryslt parameter.


-----Original Message-----
From: Gary Munroe <GMUNROE@flemingc.on.ca>
To: MIDRANGE-L@midrange.com <MIDRANGE-L@midrange.com>
Date: Wednesday, July 05, 2000 3:20 PM
Subject: OPNQRYF Question


SELECT * FROM COURSES
  WHERE SOMECODE = "" AND
  LOCATION IN
    (SELECT ID FROM TABLELOOKUP
     WHERE LEVEL = "02" AND (TABLEID = &TNAME1
           OR TABLEID = &TNAME2)
    )

Basically the user could enter up to two region names (&TNAME1
and &TNAME2) which use a lookup table containing the real location
codes that have to be compared with the codes on file.

Can someone tell me whether this is possible or not?

Thanks.


___________________________________________________________________
| Gary Munroe                                                      |
|------------------------------------------------------------------|
| I.T.S., Information Services Group  Work: gmunroe@flemingc.on.ca |
| Sir Sandford Fleming College        Home: izzi@calweb.com        |
| (705) 749-5523 x1409                                             |
|__________________________________________________________________|
+---
| 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
+---