Difference between revisions of "Recordset"
From Lianjapedia
Line 79: | Line 79: | ||
|- | |- | ||
|Column | |Column | ||
− | | | + | |ncolumn |
− | | | + | |Returns the value stored in column ncolumn for the current record in the recordset |
|- | |- | ||
|Delete | |Delete |
Revision as of 12:11, 16 February 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 |
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 | ||
Findlast | ||
Findnext | ||
Findprevious | ||
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 |
---|