Class TableSortClass
- Namespace
- ESRI.ArcGIS.Geodatabase
- Assembly
- ESRI.Server.Geodatabase.dll
[Guid("2D0F935D-32F5-11D2-A06F-0000F8775BF9")]
[ClassInterface(ClassInterfaceType.None)]
public class TableSortClass : TableSort, ITableSort2, ITableSort
- Inheritance
-
TableSortClass
- Implements
- Inherited Members
Constructors
TableSortClass()
public TableSortClass()
Explicit Interface Implementations
Ascending[string]
Field sort order.
virtual bool Ascending[string Field] { set; }
Parameters
Fieldstring
Returns
CaseSensitive[string]
Character fields case sensitive. Default: False.
virtual bool CaseSensitive[string Field] { set; }
Parameters
Fieldstring
Returns
Compare
Compare call back interface. Specify Null (default) for normal behavior.
virtual ITableSortCallBack Compare { set; }
Returns
Cursor
The cursor of the data to sort on. Ensure that sorting fields are available. Cancels SelectionSet.
virtual ICursor Cursor { set; }
Returns
Fields
Comma list of field names to sort on.
virtual string Fields { set; }
Returns
Remarks
<P>Each table in a database has an ordered collection of fields, there is always at least one field in a table. The ordered collection behaves like a list, so it is possible to access individual fields by a numbered position (or index) in the list.</P> <P>A <STRONG>Fields </STRONG>collection can also exist independently of a table, for example when creating an index on a table you will need to define which fields take part in the index. There are many interfaces which either require or return a <STRONG>Fields </STRONG>collection; these include <STRONG>IClass </STRONG>(therefore also <STRONG>IObjectClass </STRONG>and <STRONG>IFeatureClass</STRONG>), <STRONG>ICursor</STRONG>, <STRONG>IIndex</STRONG>, <STRONG>IFeatureClassDraw</STRONG>, <STRONG>IRowBuffer</STRONG>, <STRONG>ISimpleDataConverter</STRONG>, <STRONG>ITableSort </STRONG>and <STRONG>IValidate</STRONG>.</P>
IDByIndex[int]
A id by its index value.
virtual long IDByIndex[int Index] { get; }
Parameters
Indexint
Returns
IDs
List of sorted IDs.
virtual IEnumIDs IDs { get; }
Returns
ITableSort2_Ascending[string]
virtual bool ITableSort2_Ascending[string Field] { set; }
Parameters
Fieldstring
Returns
ITableSort2_CaseSensitive[string]
virtual bool ITableSort2_CaseSensitive[string Field] { set; }
Parameters
Fieldstring
Returns
ITableSort2_Compare
virtual ITableSortCallBack ITableSort2_Compare { set; }
Returns
ITableSort2_Cursor
virtual ICursor ITableSort2_Cursor { set; }
Returns
ITableSort2_Fields
virtual string ITableSort2_Fields { set; }
Returns
ITableSort2_IDByIndex[int]
virtual long ITableSort2_IDByIndex[int Index] { get; }
Parameters
Indexint
Returns
ITableSort2_IDs
virtual IEnumIDs ITableSort2_IDs { get; }
Returns
ITableSort2_QueryFilter
virtual IQueryFilter ITableSort2_QueryFilter { get; set; }
Returns
ITableSort2_Rows
virtual ICursor ITableSort2_Rows { get; }
Returns
ITableSort2_SelectionSet
virtual ISelectionSet ITableSort2_SelectionSet { get; set; }
Returns
ITableSort2_Sort(ITrackCancel)
virtual void ITableSort2_Sort(ITrackCancel TrackCancel)
Parameters
TrackCancelITrackCancel
ITableSort2_SortCharacters[string]
virtual int ITableSort2_SortCharacters[string Field] { set; }
Parameters
Fieldstring
Returns
ITableSort2_Table
virtual ITable ITableSort2_Table { get; set; }
Returns
QueryFilter
The query filter on table or selection set.
virtual IQueryFilter QueryFilter { get; set; }
Returns
Rows
Cursor of sorted rows.
virtual ICursor Rows { get; }
Returns
SelectionSet
The selection set as a source of the data to sort on. Cancels Cursor.
virtual ISelectionSet SelectionSet { get; set; }
Returns
Sort(ITrackCancel)
Sort rows.
virtual void Sort(ITrackCancel TrackCancel)
Parameters
TrackCancelITrackCancel
SortByCodedValueDescription[string]
Field sort order by coded value description.
virtual bool SortByCodedValueDescription[string Field] { set; }
Parameters
Fieldstring
Returns
SortCharacters[string]
Number of characters to sort on, for string fields. A null (default) sorts on the whole string.
virtual int SortCharacters[string Field] { set; }
Parameters
Fieldstring
Returns
Table
The table as a source of the data to sort on.
virtual ITable Table { get; set; }
Returns
Remarks
<P>A <STRONG>Table </STRONG>object has one or more columns, referred to as fields, and contains an unordered collection of rows. Each row has for each field exactly one value in the data type of the field.</P> <P>A <STRONG>Table </STRONG>is a <STRONG>Dataset </STRONG>and properties such as the name of the table, the persistable name object for the table, and the workspace containing the table, may be obtained via the <STRONG>IDataset </STRONG>interface. In relational terms, a <STRONG>Table </STRONG>object represents an RDBMS table or view. In objected-oriented terms, a Table object represents an ObjectClass or a RelationshipClass in a geodatabase. A <STRONG>Table </STRONG>object hands out <STRONG>Row </STRONG>objects which themselves support application callable methods depending on the type of data stored in the table.</P> <P>The <STRONG>Name </STRONG>property of a <STRONG>Table</STRONG>, accessible via the <STRONG>IDataset </STRONG>interface, returns its fully qualified name. The level of qualification may vary depending on the host DBMS. For example, a table named ‘pipes’, owned by a user named ‘gas’ may be called ‘pipes’ in and Access or File Geodatabase, ‘gas.pipes’ on Oracle and ‘mydb.gas.pipes’ on SQLServer. The <STRONG>ParseTableNamemethod </STRONG>on the <STRONG>ISqlSyntax </STRONG>interface supported by the table’s workspace can be used to split the fully qualified name into its components.</P>