Recordset

Properties

This class supports the Common properties plus the following:

Property	Access (R/RW)	Value	Description
Bof	R	boolean	Returns true if at beginning of file marker, otherwise false
Eof	R	boolean	Returns true if at end of file marker, otherwise false
Fieldcount	R	numeric	Number of fields
Filter	RW	string	Current filter condition, '(null)' if none set
Found	R	boolean	Returns true after the seek method if a matching record was found, false if not found
Index	RW	string	Tag name of current master index order, '0' if none set.
Nomatch	R	boolean	Returns true after the seek method if no matching record was found, false if found
Recordcount	R	numeric	Number of records
Recordnumber	R	numeric	Current record number

Methods

This class supports the Common methods plus the following:

Method	Args	Description
Addnew	none	Adds a new record to the recordset. Field values of the new record can then be modified. Complete the add/modification by calling the update method.
Close	none	Closes the recordset
Column	ncolumn	Returns the value stored in column ncolumn for the current record in the recordset
Delete	none	Marks the current record in a table recordset for deletion
Edit	none	Puts the current record in recordset in edit mode, prior to field value modification. Complete the modification by calling the update method.
Execute	commandstring	Execute the VFP/Lianja command commandstring
Fcount	none	Returns the number of fields/columns in the recordset
Fields
Findfirst	conditionstring	Moves the record pointer to the first record in the recordset to match the conditionstring condition
Findlast	conditionstring	Moves the record pointer to the last record in the recordset to match the conditionstring condition
Findnext	conditionstring	Moves the record pointer to the next record in the recordset to match the conditionstring condition
Findprevious	conditionstring	Moves the record pointer to the previous record in the recordset to match the conditionstring condition
Movebookmark
Movefirst	none	Move record pointer to first record in the recordset
Movelast	none	Move record pointer to last record in the recordset
Movenext	none	Move record pointer to next record in the recordset
Moveprevious	none	Move record pointer to previous record in the recordset
Moverelative	nrecords	Move record pointer by nrecords records: forwards if nrecords is positive, backwards if nrecords is negative
Reccount	none	Returns the number of records in the recordset
Recno	none	Returns the current record number in the recordset
Requery
Seek
SQLExecute	sqlcommandstring	Execute the SQL command string sqlcommandstring
Update	none	Completes an addnew or edit method operation

Events

This class supports the Common events plus the following:

Event	Args	Description