Re: SQL Troubles

[John Hall <jhall@xxxxxxxxxxx>]

Well that's the problem though - This generates a list of invoices for
an inquiry screen.  The user can sort them by, date, number, amount
etc.  And sort them in either ascending or descending order.  The
CheckNo lookup is one of four possible selection criteria.  The others
work fine.  I guess I may have to create a temporary file to get this to
work.  

It seems to me that there should be a way to inform the system to do
APDIST record selection and then the APINVOICV record selection.  

If I use CREATE TABLE and then DELETE TABLE there seems to be a lot of
unnecessary overhead.


John


Elena Morozova wrote:
> 
> Yes, I tried to add "order by"  or "group by".  It really makes the
> performance much worse.
> But  it seems to me that "distinct"  sorts  selected records - though I'm
> not quite sure.  I tried it on our files - the result is sorted.  So if you
> need only sorted list of invoice numbers  - may be you don't need to add in
> the sort criteria ?
>
+---
| 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
+---