RE: Problems with Query on V4R5

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

I have seen this phenomenon on the S/38.  My understanding was always this:
"If you want things in order, Sort them"  You can never depend on the
machine to present the records in a specific order unless you tell it to.

Solutions:
1) Write a program instead of a query
2) Add a sequence field (timestamp?) to the record and sort the query that
way.  You don't necessarily need to populate the timestamp field - the
system can do that for you so there aren't any other changes to your
application.

Buck Calabro
Commsoft; Albany, NY
Visit the Midrange archives and FAQ at http://www.midrange.com
"...the humourous man shall end his part in peace..."
  -- Hamlet Act II, scene ii
+---
| 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
+---