Class # RecordSetQuery --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ## Description Used to obtain as selection of records that a `Report` can use. This usage is no longer needed. You can pass a `RowSet` directly to a `Report`. ## Methods
table-centered_column_4
| Name | Parameters | Returns | Shared | |--------------------------------------------|-----------------------------------------------|------------------------------------|--------| | `Constructor` | rs As `RowSet` | | | | `EOF` | | `Boolean` | | | `Field` | Idx As `Integer` | `Variant` | | | | Name As `String` | `Variant` | | | `NextRecord` | | `Boolean` | | | `Run` | | | | | `Type` | FieldName As `String` | `Integer` | | ## Method descriptions
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
forsearch
RecordSetQuery.Constructor **Constructor**(rs as `RowSet`)
Note
`Constructors` are special methods called when you create an object with the `New` keyword and pass in the parameters above.
Creates a new RecordSetQuery from the passed `RowSet`. A `RowSet` can now be passed directly to the Run method of a Report. It is no longer necessary to first create a RecordSetQuery.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
forsearch
RecordSetQuery.EOF **EOF** As `Boolean` `True` when the record pointer is at the end of the set of records.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
forsearch
RecordSetQuery.Field **Field**(Idx As `Integer`) As `Variant` Returns the value of the Field in the row the record pointer is pointing to. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
forsearch
RecordSetQuery.Field **Field**(Name As `String`) As `Variant` Returns the value of the Field in the row the record pointer is pointing to.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
forsearch
RecordSetQuery.NextRecord **NextRecord** As `Boolean` Moves the record pointer to the next record in the RecordSetQuery.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
forsearch
RecordSetQuery.Run **Run** Does nothing and is included for compatibility.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
forsearch
RecordSetQuery.Type **Type**(FieldName As `String`) As `Integer` Returns the data type of the passed column. Please refer to the table of field types in the `Database` class notes for the numeric values corresponding to SQL data types. ## Notes Initially, the RecordSetQuery constructor was used to obtain a group of records from a `RowSet` to pass it to a `Report` in a suitable form. Please note that a `RowSet` can now be passed directly to the reporting engine. ## Compatibility All project types on all supported operating systems. ## See also `Object` parent class; `Report`, `ReportField`, `ReportLabel`, `ReportLineShape`, `ReportOvalShape`, `ReportRectangleShape`, `ReportRoundRectangleShape`, `ReportPicture` classes, `Reports Module` module.