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

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


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.


RecordSetQuery.EOF

EOF As Boolean

True when the record pointer is at the end of the set of records.


RecordSetQuery.Field

Field(Idx As Integer) As Variant

Returns the value of the Field in the row the record pointer is pointing to.


RecordSetQuery.Field

Field(Name As String) As Variant

Returns the value of the Field in the row the record pointer is pointing to.


RecordSetQuery.NextRecord

NextRecord As Boolean

Moves the record pointer to the next record in the RecordSetQuery.


RecordSetQuery.Run

Run

Does nothing and is included for compatibility.


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.