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 huge, this method does not copy the data set into the program's memory. 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.