OrderByNumber property: QueryField class

Description

Use this property to specify whether a field is used as part of an 'Order By' statement in the SQL. The number value of this property indicates which is the first field in the order by statement, which is the second, and so on.

This property is read/write.

Example

To order a query by one field, you must set the OrderByNumber property for the other QueryFields as well, specifying the primary field as 1, the next field as 2, and so on.

&QryFld = &MainQrySel.AddQuerySelectedField("PSRECDEFN", "A", "RECNAME", ⇒
"Record Name"); 
&QryFld.ColumnNumber = 1; 
&QryFld.OrderByNumber = 1; 
 
&QryFld = &MainQrySel.AddQuerySelectedField("PSRECDEFN", "A", "RECDESCR", ⇒
"Record Descr"); 
&QryFld.ColumnNumber = 2; 
&QryFld.OrderByNumber = 2; 
 
&QryFld = &MainQrySel.AddQuerySelectedField("PSRECDEFN", "A", "RELLANGRECNAME",⇒
 "Record Lang Rec"); 
&QryFld.ColumnNumber = 3; 
&QryFld.OrderByNumber = 3;