Executes an SQL statement.

Defined in

ODBCResultSet

Syntax

status = odbcResultSet.Execute

Return Value

status

Boolean.

Use this method to execute a query or any other valid SQL statement. Any existing data in the ODBCResultSet object is discarded. NumColumns changes to reflect the actual number of columns in the result set. NumRows is set to DB_ROWSUNKNOWN. IsResultSetAvailable, IsBeginOfData, IsEndOfData, and CurrentRow are all reset.

Errors

ODBC could not complete the requested operation (DBstsODBC)

Note GetExtendedErrorMessage contains the message, if any, returned by the data source.

Events

BeforeExecute

AfterExecute

Example
See Also

IsResultSetAvailable method
Query property
NumColumns method
NumRows method
SetParameter method

Glossary