ICommenceCursor Interface

Name of the category this cursor is based on.

Number of columns in cursor.

Allows for setting multiple direct and related columns at once.

Gets collection of filters to be applied on cursor. It is recommended you use this property over setting filterstrings directly.

Maximum field size. Gets the maximum number of characters that can be read from a Commence field. Undocumented by Commence. The default value is 93750.

Maximum number of rows a cursor can contain. Undocumented by Commence. Effectively a measure for database capacity.

Number of items in cursor.

(read-only) TRUE if category is shared in a workgroup.

Name of the View if cursor is based on a view.

Close any references to Commence. The object should be disposed after this.

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

Exports current cursor to a file. WARNING: The cursor is disposed after this method!

Create a rowset of new items to add to the database.

Get columnames from cursor. Defaults to fieldnames

Create a rowset of ALL existing items for deletion. Use with care!

Create a rowset of n items for deletion.

Create a rowset for deleting a particular row.

Create a rowset of all existing items for editing. Be careful when handling very large rowsets.

Create a rowset of existing items for editing.

Create a rowset for editing a particular row.

Create a rowset object with the results of a query.

Create a rowset object with the results of a query.

Create a rowset object with a particular row loaded.

Create a rowset object with a particular thid loaded. Only applies to shared items. Cursor must have the thids thids flag.

Checks if field contains duplicate values.

Read all data from a cursor.

This method is just a convenient way to return data without having to create a ICommenceQueryRowSet.

Keep in mind reading data from Commence is quite slow!

For more advanced reading and export options see IExportEngine.

Reads specified row from the cursor.

This method is just a convenient way to return data without having to create a ICommenceQueryRowSet.

If you need to apply formatting, see the IExportEngine interface.

Seek to row in cursor.

Move a fractional number of rows.

Set active date used for view cursors using a view linking filter.

Set active date range used for view cursors using a view linking filter.

Set active item used for view cursors using a view linking filter.

Defines the column set for the cursor

Allows for setting direct columns in batch-mode

Defines the filter for the cursor. Not recommended, use Filters instead.

Defines the filter logic for the cursor. Not recommended, use Filters instead.

Define column for a connected field. Allows for retrieving other than just the Name field from connections.

Defines the sort criteria for the cursor. Use this only if you apply filters with the SetFilter method. You are strongly advised to use the Filters collection instead.