Easy to Create, Easy to Change - Easy to use!


in order





in order


Sorting Operator


The in order operator tells DataEase to process records and display the output in sequence from lowest to highest value in the specified field. (e.g. 01011, before 01012, before 01013, etc.).


FIELDNAME in order ;|.


The in order operator can be used only on list items following the list records command. It cannot be used with the enter a record, modify records, or delete records commands.

The in order operator can be used on any type of field. A Time, Date, or Number field is ordered from lowest to highest value. A Choice field is sorted by Choice number. A Text field is sorted in alphabetical order.

DataEase orders alphanumeric values in standard ASCII sequence and makes no distinction between upper and lower case.

If a script specifies an item to be processed in groups, that item should be listed before all other output items in a script, including items to be sorted in order. When a field is listed in groups, DataEase also sorts the groups in order (e. g., when grouping MEMBERS by STATE, all Alabama members are listed before any Alaska members).



Sorting operators cannot be used in conjunction with the all relational operator (e.g., if RESERVATIONS is the Primary table, you cannot use the statement:


all MEMBERS LAST NAME in order ;




list records

STATE in groups ;

ZIP CODE in order ;

LAST NAME in order .



This script tells DataEase: (1) Process all the RESERVATIONS records with the same value in the STATE field together as a group, (2)display the group identifier STATE once at the beginning of each group, (3) within each group, arrange the members in order from lowest to highest ZIP CODE, and (4) within each ZIP CODE, arrange the members in alphabetical order by LAST NAME. A portion of the output from this script might look as follows:




Zip Code

Last Name





























See Also

On the forum about in order

List Subform Records In Order

Hi All,How do I list subform records in alpha or numeric order? For example let’s say the subform contains first and last names and I want the last names displayed in order then first names in order. When I select the “Order Alphabetical” ch...

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 22/01/20 at 16:08:03

Re:List Subform Records In Order

Hi there...I think you can look in "query by model" there you can define what you need.Kind regardsMarkus...

Product: Dataease [{8}]FIVE. Written by Markus 22/01/20 at 16:57:37

Re:List Subform Records In Order

Hi. You are in the wrong ballpark here my friend.This is for listing fields in alphabetical order when you create the layout.What you are looking for is the QBM. Here you can sort, filter...

Product: Dataease [{8}]FIVE. Written by DataEase 22/01/20 at 18:10:34

Re:Re:List Subform Records In Order

Thank you so much for your help. I tried this and it didn't seem to work for me. I'm sure it is something I am doing wrong. I was wondering if your app is available for download or if there was a simple app that I could download using QBM....

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 24/01/20 at 16:39:32

Re:Re:Re:List Subform Records In Order

Download Sample It is quite straight forward when you get the hang of it. ...

Product: Dataease [{8}]FIVE. Written by DataEase 25/01/20 at 22:36:32

Re:Re:Re:Re:List Subform Records In Order

Thank you very much for your help. Once I created a simple form with one subform it worked great. My other form will never work however because it is several subforms deep I.E. subform in a subform in a subform… Thanks again for your help th...

Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 29/01/20 at 22:58:15

Re:Re:Re:Re:Re:List Subform Records In Order

You can order on as many levels as you like. But you can't directly order a level further out based on something which is lower down.It is hard to say how you can get it right without seeing what you try to do.is this a subform for edi...

Product: Dataease [{8}]FIVE. Written by DataEase 01/02/20 at 11:38:33

On the blog about in order