RE: SQL select via logicals

["Cotes, Steven" <cotess@xxxxxxxxxxx>]

Walden,
I don't have the psychiatric credentials to comment on a couple of your
questions.
Some phrase about stones and glass houses also comes to mind.

So,
what you saw is how it's meant to work.
Logicals containing select/omit criteria only point to (include) records
that meet the
criteria. Any query built over the logical (SQL, OPNQRYF, ..) will only
return records
within the logical's criteria.

 - Enjoy the Holly Daze ...
 -Steve Cotes
 -cotess@data-io.com

> ----------
> From:         Walden Leverich[SMTP:walden@techsoftinc.com]
> Sent:         Tuesday, November 25, 1997 10:18 AM
> To:   Midrange List
> Subject:      SQL select via logicals
> 
> Am I losing my mind? (Don't answer that!) Anyway, if I am issuing a
> select
> over a logical and that logical has select/omit but I do NOT specify
> that
> select/omit in my where clause I thought that SQL would not use that
> select
> criteria. I just saw an example that led me to believe that this was
> not the
> case. That is to say, if I select * from lgl1 and lgl1 has select
> criteria
> then the select will only have the records in the result set that
> match the
> selection criteria. Am I nuts?
> 
> -Walden
> 
> 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@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
+---