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

Support::

in order



Parameters


Returns/Result


Examples


Reference

in order

Type

Sorting Operator

Purpose

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.).

Syntax

FIELDNAME in order ;|.

Usage

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).

 

Caution

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 ;

 

Example

for RESERVATIONS ;

list records

STATE in groups ;

ZIP CODE in order ;

LAST NAME in order .

end

 

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:

 

 

State

Zip Code

Last Name

...

...

...

DC

 

 

 

20007-3947

Spinelli

 

20036-0000

Dowling

 

20036-8749

Schmidt

DE

 

 

 

19810-3729

Stromboulis

 

19901-3445

Gross

...

...

...

 

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