Click or drag to resize

CommenceCursor Methods

The CommenceCursor type exposes the following members.

Methods
  NameDescription
Public methodClose
Close any references to Commence. The object should be disposed after this.
Public methodDispose
Public implementation of Dispose pattern callable by consumers.
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodExportToFile
Exports current cursor to a file. WARNING: The cursor is disposed after this method!
Public methodGetAddRowSet
Create a rowset of new items to add to the database.
Public methodGetColumnNames
Get columnames from cursor. Defaults to fieldnames
Public methodGetDeleteRowSet(CmcOptionFlags)
Create a rowset of ALL existing items for deletion. Use with care!
Public methodGetDeleteRowSet(Int32, CmcOptionFlags)
Create a rowset of n items for deletion.
Public methodGetDeleteRowSetByID
Create a rowset for deleting a particular row.
Public methodGetEditRowSet(CmcOptionFlags)
Create a rowset of all existing items for editing. Be careful when handling very large rowsets.
Public methodGetEditRowSet(Int32, CmcOptionFlags)
Create a rowset of existing items for editing.
Public methodGetEditRowSetByID
Create a rowset for editing a particular row.
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetQueryRowSet(CmcOptionFlags)
Create a rowset object with the results of a query.
Public methodGetQueryRowSet(Int32, CmcOptionFlags)
Create a rowset object with the results of a query.
Public methodGetQueryRowSetByID
Create a rowset object with a particular row loaded.
Public methodGetQueryRowSetByThid
Create a rowset object with a particular thid loaded. Only applies to shared items. Cursor must have the thids thids flag.
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodHasDuplicates
Checks if field contains duplicate values.
Public methodReadAllRows
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.

Public methodReadRow
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.

Public methodSeekRow
Seek to row in cursor.
Public methodSeekRowApprox
Move a fractional number of rows.
Public methodSetActiveDate
Set active date used for view cursors using a view linking filter.
Public methodSetActiveDateRange
Set active date range used for view cursors using a view linking filter.
Public methodSetActiveItem
Set active item used for view cursors using a view linking filter.
Public methodSetColumn
Defines the column set for the cursor
Public methodSetColumns
Allows for setting direct columns in batch-mode
Public methodSetFilter
Defines the filter for the cursor. Not recommended, use Filters instead.
Public methodSetLogic
Defines the filter logic for the cursor. Not recommended, use Filters instead.
Public methodSetRelatedColumn
Define column for a connected field. Allows for retrieving other than just the Name field from connections.
Public methodSetSort
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.
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also