OrderSpec Properties

A logical value specifying whether open orders should remain open while the new order is being created.

A logical value determining whether the record scope is for all records in the DBF (TRUE)

Determines if this index file will open when the DBF file is opened.

Determines if this index file will set the first order when it is opened.

Determines if this index file will be opened in the same share mode as the DBF file.

A logical value determining whether only those records in the controlling order and in the scope are included in this order. Defaults to FALSE so that all records in DBF are included.

A logical value determining if this is to be a custom order. Valid for RDDs that support custom orders. Defaults to FALSE for a non-custom order.

The DBFileSpec object with which this OrderSpec object is associated.

A logical value determining if this is to be a descending order. Defaults to FALSE for ascending order.

The code block to be evaluated based upon OrderSpec:Interval. The code block should return a TRUE value.

The drive, path and file name of the order. The drive and path default to either the current window's drive and path or to the drive and path used in SetDefault(), if omitted.

The FOR condition code block to build this order.

The FOR condition string used to build this order.

A logical value determining whether the DBFNTX RDD will use the HPLocking scheme for building this order. The default is FALSE, i.e., no HPLocking.

An integer determining the interval for the execution of OrderSpec:EvalBlock during order building.

A logical value indicating whether this is a conditional order. This is assigned TRUE internally when any of the conditional ASSIGNs are assigned values and is not required to be assigned manually to create a conditional order.

The 1-D, 4-element array containing the structure of the OrderSpec object.

The current NTX locking offset as a numeric value.

A logical value determining whether the FOR condition used to build this order should be optimized. Valid for RDDs that support query optimizations. Defaults to FALSE for no optimization.

The code block of the index key expression used to create this order.

The string of the index key expression used to create this order.

The order (tag) name for this order. Used for creating multi-order order files (bags).

The individual record number to be processed. Defaults to zero (0) for all records.

The number of records to be processed starting from OrderSpec:Start.

A logical value indicating that records are to be processed starting from OrderSpec:Start (TRUE). Defaults to FALSE to process all records from the beginning of file.

Determines the starting record number from which to start building this order.

A logical value determining whether the records will be read directly from disk during order creation.

A logical value determining whether this order is to be a unique order (no duplicate keys).

A WHILE condition code block used during the building of this order.