Edit-DB Edit-DB
(c) Nigel Maddocks, 2007
Edit-DB ver 2.05.016, Doc ver 2.05.016

3.2. Record ordering

* Also applies to Views

The easiest way to sort the selected records is to click on the column name in the header section of the displayed table or view. This will initially sort that column into ascending order. Clicking again on the column name will sort the column into descending order. Clicking for a third time on the column name reverts back to ordering into ascending order. This will suffice for the majority of times that ordering is required.

To fine tune the ordering of records, it may be necessary to use the Order miniature text-box available for each column next to the column's record selection text-box.

Specify WHERE

The rules are that a 1 against a column indicates that the column is to be used as the primary "order by" column. A 2 against a column indicates that the column is to be used as the secondary "order by" column, etc. A letter d after the number indicates that the column should be sorted in descending order. If you choose to enter the criteria by hand, then press Enter or Requery to effect the new settings.

The order by text-boxes are also available on the Record Selection Display shown in the previous section.