Difference between revisions of "Recordset"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 3: | Line 3: | ||
This class supports the [[:Category:Common_Properties|Common Properties]] plus the following: | This class supports the [[:Category:Common_Properties|Common Properties]] plus the following: | ||
− | {| class="wikitable" | + | {| class="wikitable" width=100% |
!width="20%"|Property | !width="20%"|Property | ||
!Access (R/RW) | !Access (R/RW) | ||
Line 60: | Line 60: | ||
This class supports the [[:Category:Common_Methods|Common Methods]] plus the following: | This class supports the [[:Category:Common_Methods|Common Methods]] plus the following: | ||
− | {| class="wikitable" | + | {| class="wikitable" width=100% |
!width="20%"|Method | !width="20%"|Method | ||
!Args | !Args | ||
Line 167: | Line 167: | ||
This class supports the [[:Category:Common_Events|Common Events]] plus the following: | This class supports the [[:Category:Common_Events|Common Events]] plus the following: | ||
− | {| class="wikitable" | + | {| class="wikitable" width=100% |
!width="20%"|Event | !width="20%"|Event | ||
!Args | !Args |
Revision as of 13:36, 8 January 2013
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 |
---|