Indicates whether the BindingSource object automatically sorts records in the ABL data source object when some user action in the bound .NET control generates a sort operation (such as clicking on a column header in a grid control).
You can use this property when the BindingSource object is bound to a query. If bound to a ProDataSet object, this property applies only to the top-level table displayed in the .NET control.
This property applies only to .NET controls that rely on their data source for sorting.
The query must have been opened with the QUERY-PREPARE and QUERY-OPEN methods (not the OPEN QUERY statement). Otherwise, the AVM generates a run-time error.
Note: Progress Software Corporation recommends that you open the query using the PRESELECT option, which optimizes query performance.
When TRUE, and the user initiates a sort request, the BindingSource object reopens the query associated with the ABL data source object with an appropriate BY phrase, which resorts the data in the ABL data source object. The BindingSource object replaces any existing BY phrase in the query. For more information about the BY phrase, see the OPEN QUERY statement reference entry.
When FALSE, the BindingSource object raises a SortRequest event that the application can trap and handle. If the application does not handle the event, the data in the ABL data source object is not resorted. The default value is FALSE.
If record batching is enabled (that is, the Batching property is TRUE), the BindingSource object resorts only the records in the current result set.
