IDalCursor

Description

The IDalCursor interface contains properties and methods used to work with cursor received after executing SQL query to the database.

Comments

Cursor is a cached table that was received after executing SQL query. Cursor supports only forward navigation through data. Cursor is not updated, that is if values in the tables were changed on the server, repeat SQL query execution and create new cursor to receive new data.

Working with the database server, there is a limit on the number of cursors opened simultaneously, that is why user should close unused cursors timely using the Close method.

Properties

	Property name	Brief description
	Fields	The Fields property returns a collection of fields of the cursor that was received after executing SQL query.
	Command	The Command property returns an object used to work with database using the SQL queries.

Methods

	Method name	Brief description
	Close	The Close method closes a cursor.
	Eof	The Eof method returns whether the current record is last in the table that became a result of command execution on the database server.
	Next	The Next method implements transition to the next record in the table that became a result of command execution on the database server.