Recordset
From Lianjapedia
Revision as of 12:18, 16 February 2012 by Lianjasupport (Talk | contribs)
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 |
| Fields | R | object | |
| 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 | ||
| Close | ||
| Column | ncolumn | Returns the value stored in column ncolumn for the current record in the recordset |
| Delete | ||
| Edit | ||
| 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 |
Events
This class supports the Common events plus the following:
| Event | Args | Description |
|---|
