Difference between revisions of "Recordset"
From Lianjapedia
Helen.george (Talk | contribs) |
Barrymavin (Talk | contribs) (→Events) |
||
(5 intermediate revisions by 2 users not shown) | |||
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 | ||
− | |||
− | |||
− | |||
− | |||
− | |||
|- | |- | ||
|Filter | |Filter | ||
Line 67: | Line 62: | ||
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 87: | ||
|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 | ||
|- | |- | ||
|valign="top"|Fields | |valign="top"|Fields | ||
|valign="top"|[fieldname as Character | fieldnumber as Numeric] | |valign="top"|[fieldname as Character | fieldnumber as Numeric] | ||
− | |valign="top"|Return an object reference to the specified | + | |valign="top"|Return an object reference to the specified [[Field]] in the current record |
|- | |- | ||
|valign="top"|FindFirst | |valign="top"|FindFirst | ||
Line 144: | Line 139: | ||
|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 155: | ||
|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 | ||
|- | |- | ||
|} | |} | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Framework Classes]] | [[Category:Framework Classes]] | ||
+ | [[Category:Working with Data]] |
Latest revision as of 11:28, 10 April 2019
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 |
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 |