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
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.