Open topic with navigation

Retrieving external data with script-generated queries

If you use multiple sets of data from one external data source, you can configure a single external datasheet and use a script-generated query to retrieve a recordset during playback instead of creating multiple external datasheets to retrieve multiple recordsets. This allows you to perform a dynamic query on a data source during playback.

Script-generated queries can only be used for external datasheets linked to a data source. All data is stored in the external source and you cannot view the data in QA Wizard Pro.

You can use the OpenRecordsetQuery statement to perform the query on the data source.

1. Use the Create Datasheet wizard to create an external datasheet that links to a data source. Make sure you select the Link to data in external source option in the datasheet options. See Configuring external datasheets.

2. Select Script-generated query in the datasheet information.

3. Add the OpenRecordsetQuery statement to a script to specify the data to open from the external data source during playback. See OpenRecordsetQuery.

Example

In the following script, the OpenRecordsetQuery statement uses the SELECT * FROM Email SQL query to retrieve all columns and rows from the Email table in the database linked to the Customers external datasheet. The recordset is assigned to the myRecordset variable. The RecordsetRowCount statement returns the number of rows in the recordset and assigns the number to the count variable. The PrintLn statement prints the number of rows stored in the count variable.

myRecordset = OpenRecordsetQuery("Customers", "SELECT * FROM Email")

count = RecordsetRowCount(myRecordset)

PrintLn(count)