Difference between revisions of "Recordset"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| Line 5: | Line 5: | ||
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" width=100% | + | {| class="wikitable" width="100%" |
!width="20%"|Property | !width="20%"|Property | ||
!Access (R/RW) | !Access (R/RW) | ||
| Line 21: | Line 21: | ||
|valign="top"|Whether record pointer is at end of recordset | |valign="top"|Whether record pointer is at end of recordset | ||
|- | |- | ||
| − | |valign=top|FieldCount | + | |valign="top"|FieldCount |
| − | |valign=top|R | + | |valign="top"|R |
| − | |valign=top|Numeric | + | |valign="top"|Numeric |
|Number of fields in the dataset | |Number of fields in the dataset | ||
|- | |- | ||
| − | |valign=top|Fields | + | |valign="top"|Fields |
| − | |valign=top|R | + | |valign="top"|R |
| − | |valign=top|Object | + | |valign="top"|Object |
|Reference to the current record's fields | |Reference to the current record's fields | ||
|- | |- | ||
| Line 67: | Line 67: | ||
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" width=100% | + | {| class="wikitable" width="100%" |
!width="20%"|Method | !width="20%"|Method | ||
!Args | !Args | ||
| Line 92: | Line 92: | ||
|Puts the current record in recordset in edit mode, prior to field value modification. Complete the modification by calling the update method. | |Puts the current record in recordset in edit mode, prior to field value modification. Complete the modification by calling the update method. | ||
|- | |- | ||
| − | |valign=top|Execute | + | |valign="top"|Execute |
|command as Character | |command as Character | ||
| − | |valign=top|Execute the command | + | |valign="top"|Execute the command |
|- | |- | ||
| − | |valign=top|Fcount | + | |valign="top"|Fcount |
| − | |valign=top|None | + | |valign="top"|None |
|Returns the number of fields/columns in the recordset | |Returns the number of fields/columns in the recordset | ||
|- | |- | ||
| Line 144: | Line 144: | ||
|Move record pointer by numrecords records: forwards if numrecords is positive, backwards if numrecords is negative | |Move record pointer by numrecords records: forwards if numrecords is positive, backwards if numrecords is negative | ||
|- | |- | ||
| − | |valign=top|RecCount | + | |valign="top"|RecCount |
| − | |valign=top|None | + | |valign="top"|None |
|Return the number of records in the recordset | |Return the number of records in the recordset | ||
|- | |- | ||
| Line 160: | Line 160: | ||
|valign="top"|Search the index for the first record to match the key. The operator (=, >, <) may optionally be specified. | |valign="top"|Search the index for the first record to match the key. The operator (=, >, <) may optionally be specified. | ||
|- | |- | ||
| − | |valign=top|SQLExecute | + | |valign="top"|SQLExecute |
|sqlcommand as Character | |sqlcommand as Character | ||
| − | |valign=top|Execute the SQL command | + | |valign="top"|Execute the SQL command |
|- | |- | ||
| − | |valign=top|Update | + | |valign="top"|Update |
| − | |valign=top|None | + | |valign="top"|None |
|Completes an addnew or edit method operation | |Completes an addnew or edit method operation | ||
|- | |- | ||
| Line 174: | Line 174: | ||
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" width=100% | + | {| class="wikitable" width="100%" |
!width="20%"|Event | !width="20%"|Event | ||
!Args | !Args | ||
Revision as of 10:13, 4 February 2013
Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.
Properties
This class supports the Common Properties plus the following:
| Property | Access (R/RW) | Value | Description |
|---|---|---|---|
| Bof | R | Boolean | Whether record pointer is at beginning of dataset |
| Eof | R | Boolean | Whether record pointer is at end of recordset |
| FieldCount | R | Numeric | Number of fields in the dataset |
| Fields | R | Object | Reference to the current record's fields |
| Filter | RW | Character | Filter expression to restrict records |
| Found | R | Boolean | Whether the last seek or find operation found a matching record |
| Index | RW | Character | Name of the index tag |
| NoMatch | R | Boolean | Whether the last seek or find operation did not find any matching records |
| RecordCount | R | Numeric | Number of records in the dataset |
| RecordNumber | R | Numeric | Number of the current record in the dataset |
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 | columnumber as Numeric | Return the value of the specified column in the current record |
| 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 | command as Character | Execute the command |
| Fcount | None | Returns the number of fields/columns in the recordset |
| Fields | [fieldname as Character | fieldnumber as Numeric] | Return an object reference to the specified field in the current record |
| FindFirst | condition as Character | Move the record pointer to the first record in the recordset to match the condition |
| FindLast | condition as Character | Move the record pointer to the last record in the recordset to match the condition |
| FindNext | condition as Character | Move the record pointer to the next record in the recordset to match the condition |
| FindPrevious | condition as Character | Move the record pointer to the previous record in the recordset to match the condition |
| MoveBookmark | bookmark as Numeric | Move bookmark to the specified record number in the recordset |
| 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 | numrecords as Numeric | Move record pointer by numrecords records: forwards if numrecords is positive, backwards if numrecords is negative |
| RecCount | None | Return the number of records in the recordset |
| RecNo | None | Return the current record number in the recordset |
| Requery | None | Requery the recordset |
| Seek | [operator as Character,] key as Character | Search the index for the first record to match the key. The operator (=, >, <) may optionally be specified. |
| SQLExecute | sqlcommand as Character | Execute the SQL command |
| Update | None | Completes an addnew or edit method operation |
Events
This class supports the Common Events plus the following:
| Event | Args | Description |
|---|
