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

Field string

Returns

bool

CaseSensitive[string]

Character fields case sensitive. Default: False.

virtual bool CaseSensitive[string Field] { set; }

Parameters

Field string

Returns

bool

Compare

Compare call back interface. Specify Null (default) for normal behavior.

virtual ITableSortCallBack Compare { set; }

Returns

ITableSortCallBack

Cursor

The cursor of the data to sort on. Ensure that sorting fields are available. Cancels SelectionSet.

virtual ICursor Cursor { set; }

Returns

ICursor

Fields

Comma list of field names to sort on.

virtual string Fields { set; }

Returns

string

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

Index int

Returns

long

IDs

List of sorted IDs.

virtual IEnumIDs IDs { get; }

Returns

IEnumIDs

ITableSort2_Ascending[string]

virtual bool ITableSort2_Ascending[string Field] { set; }

Parameters

Field string

Returns

bool

ITableSort2_CaseSensitive[string]

virtual bool ITableSort2_CaseSensitive[string Field] { set; }

Parameters

Field string

Returns

bool

ITableSort2_Compare

virtual ITableSortCallBack ITableSort2_Compare { set; }

Returns

ITableSortCallBack

ITableSort2_Cursor

virtual ICursor ITableSort2_Cursor { set; }

Returns

ICursor

ITableSort2_Fields

virtual string ITableSort2_Fields { set; }

Returns

string

ITableSort2_IDByIndex[int]

virtual long ITableSort2_IDByIndex[int Index] { get; }

Parameters

Index int

Returns

long

ITableSort2_IDs

virtual IEnumIDs ITableSort2_IDs { get; }

Returns

IEnumIDs

ITableSort2_QueryFilter

virtual IQueryFilter ITableSort2_QueryFilter { get; set; }

Returns

IQueryFilter

ITableSort2_Rows

virtual ICursor ITableSort2_Rows { get; }

Returns

ICursor

ITableSort2_SelectionSet

virtual ISelectionSet ITableSort2_SelectionSet { get; set; }

Returns

ISelectionSet

ITableSort2_Sort(ITrackCancel)

virtual void ITableSort2_Sort(ITrackCancel TrackCancel)

Parameters

TrackCancel ITrackCancel

ITableSort2_SortCharacters[string]

virtual int ITableSort2_SortCharacters[string Field] { set; }

Parameters

Field string

Returns

int

ITableSort2_Table

virtual ITable ITableSort2_Table { get; set; }

Returns

ITable

QueryFilter

The query filter on table or selection set.

virtual IQueryFilter QueryFilter { get; set; }

Returns

IQueryFilter

Rows

Cursor of sorted rows.

virtual ICursor Rows { get; }

Returns

ICursor

SelectionSet

The selection set as a source of the data to sort on. Cancels Cursor.

virtual ISelectionSet SelectionSet { get; set; }

Returns

ISelectionSet

Sort(ITrackCancel)

Sort rows.

virtual void Sort(ITrackCancel TrackCancel)

Parameters

TrackCancel ITrackCancel

SortByCodedValueDescription[string]

Field sort order by coded value description.

virtual bool SortByCodedValueDescription[string Field] { set; }

Parameters

Field string

Returns

bool

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

Field string

Returns

int

Table

The table as a source of the data to sort on.

virtual ITable Table { get; set; }

Returns

ITable

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>