Execute

Description

Runs the query and fills the result set with data.

This method runs the query and creates the resulting data set in the database. Because the resulting data set could be quite large, this method does not copy the data set into the program's memory. You can limit the result set by using the MaxResultSetRows method. When this method returns, the cursor is positioned before the first record. You must call the MoveNext method before retrieving the first record's values. To retrieve values from a record, use the GetColumnValue method.

After executing the query, it is legal to get the SQL for the query by invoking the GetSQL method.

You may call this method more than once. For example, you might want to rerun the query if the data could have changed since the last time, or if you made changes to the database yourself.

Syntax

VBScript

resultset.Execute 

Perl

$resultset->Execute(); 

Identifier

Description

resultset

A ResultSet object, representing the rows and columns of data resulting from a query.

Return value

None.

Examples

VBScript

ResultSet.EnableRecordCount
ResultSet.Execute
count = ResultSet.RecordCount 

Perl

$resultset->EnableRecordCount();
$resultset->Execute();
$count = $resultset->GetRecordCount();