4D v18
_o_ORDER SUBRECORDS BY
- 4D Language Reference
-
- Deprecated Commands
-
- _o_ADD SUBRECORD
- _o_ALL SUBRECORDS
- _o_APPLY TO SUBSELECTION
- _o_ARRAY STRING
- _o_Before subselection
- _o_C_GRAPH
- _o_C_INTEGER
- _o_C_STRING
- _o_CREATE SUBRECORD
- _o_CREATE USER FORM
- _o_DATA SEGMENT LIST
- _o_DELETE SUBRECORD
- _o_DELETE USER FORM
- _o_DISABLE BUTTON
- _o_Document creator
- _o_Document type
- _o_DRAG AND DROP PROPERTIES
- _o_During
- _o_EDIT FORM
- _o_ENABLE BUTTON
- _o_End subselection
- _o_EXPORT ODBC
- _o_FIRST SUBRECORD
- _o_Font name
- _o_FORM GET PARAMETER
- _o_Gestalt
- _o_IMPORT ODBC
- _o_INTEGRATE LOG FILE
- _o_LAST SUBRECORD
- _o_LIST USER FORMS
- _o_Mac to Win
- _o_MAP FILE TYPES
- _o_MOBILE Return selection
- _o_MODIFY SUBRECORD
- _o_NEXT SUBRECORD
- _o_NO TRACE
- _o_OBJECT Get action
- _o_OBJECT SET COLOR
- _o_ORDER SUBRECORDS BY
- _o_PAGE SETUP
- _o_PICTURE TO GIF
- _o_PLATFORM PROPERTIES
- _o_PREVIOUS SUBRECORD
- _o_QUERY SUBRECORDS
- _o_Records in subselection
- _o_REDRAW LIST
- _o_SET DOCUMENT CREATOR
- _o_SET DOCUMENT TYPE
- _o_USE EXTERNAL DATABASE
- _o_USE INTERNAL DATABASE
- _o_Win to Mac
4D v18
_o_ORDER SUBRECORDS BY
_o_ORDER SUBRECORDS BY
| _o_ORDER SUBRECORDS BY ( subtable ; subfield {; > or <}{; subfield2 ; > or <2 ; ... ; subfieldN ; > or <N} ) | ||||||||
| Parameter | Type | Description | ||||||
| subtable | Subtable |
|
Subtable by which to order the selected subrecords | |||||
| subfield | Subfield |
|
Subfield on which to order by for each level | |||||
| > or < | Operator |
|
Ordering direction for each level: > to order in ascending order or < to order in descending order | |||||
Subtables are no longer supported starting with version 11 of 4D. A compatibility mechanism ensures the functioning of this command in converted databases; however, it is strongly recommended to replace any subtables with standard related tables.
PROPERTIES
Product: 4D
Theme: Deprecated Commands
Number:
107
HISTORY
Modified: 4D v11 SQL
Renamed: 4D v15
ARTICLE USAGE
4D Language Reference ( 4D v18)
© 1985-2020 4D SAS / 4D, Inc. All rights reserved.