Cursor

Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.

Properties

This class supports the Common Properties plus the following:

Property	Access (R/RW)	Value	Description
Bof	R	Boolean	Whether record pointer is at beginning of cursor
Database	R	Character	The name of the database associated with the cursor
Eof	R	Boolean	Whether record pointer is at end of cursor
Filter	RW	Character	Filter condition for the cursor
Table	R	Character	The name of the table associated with the cursor

Methods

This class supports the Common Methods plus the following:

Method	Args	Description
_delete	None *	Deletes a record from the database table on the server based on the current recno.
Add	None	Clears the internal record buffer in preparation for insert() being called after setData().
GetData	column as string	Get the value of the specified column from the active record.
Insert	None *	Creates a new record in the database table on the server containing the column data values that were changed by setData(). Used in conjunction with add() and setData().
MoveBookmark	record as Numeric	Positions on the specified record in the cursor then refreshes the active record of the cursor from the server.
MoveFirst	None *	Positions on the first record in the cursor then refreshes the active record of the cursor from the server.
MoveLast	None *	Positions on the last record in the cursor then refreshes the active record of the cursor from the server.
MoveNext	None *	Positions on the next record in the cursor then refreshes the active record of the cursor from the server.
MovePrevious	None *	Positions on the previous record in the cursor then refreshes the active record of the cursor from the server.
Read	None *	Reads a record from the database table on the server based on the current recno. If the recno is greater than the reccount then the last record will be read.
Refresh	None *	Refreshes the active record of the cursor from the server based on the current filter and searchfilter conditions or the current recno if neither are specified.
SetData	column as Character, value as Expression	Set the value of the specified column in the active record.
Update	None *	Updates the current record in the database table on the server containing the column data values that were changed by SetData().

Events

This class supports the Common Events plus the following:

Event	Args	Description