Execute method

Executes a SQL statement which does not produce a recordset. Returns the number of records affected.

Applies to

TableData	ArrData	RsetData	Xdata	XShared
		✓

Parameters

Name	Type	Description
SQL	String	SQL statement to be executed.

Execute is used with SQL statements which do not return a recordset such as DELETE.

If the method fails, the error number is stored in the RsetData object's ErrNumber property.