OpenRecordset

Returns a recordset object opened from a datasheet. The value is generally assigned to a variable for use with database statements, such as GetRowValue.

Note: A primary key must be defined in the table if you want to add or update rows. If a primary key is not defined, QA Wizard Pro opens the table as read-only.

Syntax

OpenRecordset("DatasheetName")

Arguments

Argument Description
DatasheetName Local or external datasheet to open. Must be in the current workspace.

Return value

Value Description
Value Recordset object opened from the datasheet.

Example

bugs = OpenRecordset("WysiCorp Bugs")

product = GetRowValue(bugs, "Product")