RE: RUNQRY *N (logicalfile)

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

Tim,
it will depend on what you mean by "quicky query".

If you are using record selection (WHERE) then the engine
will do it's own grouping, using what indexes it finds (or creates)
to return a valid set of records to you. This is the nature of "set
based"
tools.

If you don't have any WHERE clauses, just field selection, then
the results should be returned in the same order as the index.

To force the results to be in the same order as the logical keys,
you need to use ORDER BY.

 -HTH
 -steve cotes
 -cotess@data-io.com
> ----------
> From:         Tim Truax[SMTP:truax@usaor.net]
> Sent:         Thursday, July 02, 1998 2:36 PM
> To:   MIDRANGE-L list
> Subject:      RUNQRY *N (logicalfile)
> 
> Hello all,
> I am curious...  Why when you run a quicky query of a logical (file)
> view of a physical file to *display,  why doesn't the data display on
> the screen the way the logical is keyed?
> ----
> Tim & Dana Truax... and Caleb 4 years old.
> 
> 
+---
| 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
+---