Sort Object

See Also

Category Data Query
Default Catalog Visual FoxPro Catalog\Foundation Classes\Data Query
Class _tablesort
Base Class Custom
Class Library _table.vcx
Parent Class _table
Sample ...\Samples\Vfp98\Solution\Ffc\datasort.scx

Remarks

This class, when placed on a form, enables you to sort a datasource.

To use, drop the class on a project or form or, from the Component Gallery Item Shortcut menu, select Add to Project or Add to Form. When you add the class to a form, Visual FoxPro places the class icon on the form. You can then specify the appropriate property values and provide any necessary input and output objects. When you drop the class on a project, you can choose between adding the class or creating a subclass.

See Guidelines for Using Visual FoxPro Foundation Classes for more information on using foundation classes.

Properties, Events, Methods Description
lDescending property Specifies whether the sort order is ascending or descending.
Default: .F.
DoSort method Allows you to sort on the current field or to specify the field on which to order a table or alias.
Syntax: DoSort([tcField] [,tcAlias] [,tcTag] [,tlDescending])
Return: none
Arguments:
tcField specifies the field to sort on.
tcAlias specifies the alias of the table to sort.
tcTag specifies the index tag of the field, tcField.
tlDescending specifies whether the sort is a descending sort.
GetSortTag method Looks for an appropriate tag name by looking at key expressions in the table relevant to the field name.
Syntax: Getsorttag(tcField, tcAlias)
Return: lcTag
Arguments:
tcField specifies the field to sort on.
tcAlias specifies the alias of the table to sort.
RemoveSort method Removes the current index tag.
Syntax: RemoveSort(tcAlias)
Return: none
Arguments:
tcAlias specifies the alias of the table from which to remove the tag.