Difference between revisions of "Recordset"
From Lianjapedia
Line 159: | Line 159: | ||
|Update | |Update | ||
|none | |none | ||
− | |Completes an addnew | + | |Completes an addnew or edit method operation |
|- | |- | ||
|} | |} |
Revision as of 08:47, 1 March 2012
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 | ||
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 | ||
Update | none | Completes an addnew or edit method operation |
Events
This class supports the Common events plus the following:
Event | Args | Description |
---|