Top Previous Next

Executes the stored procedure on the server.


procedure ExecProc;


Call ExecProc to execute a stored procedure on the server. Before calling ExecProc:

      • Provide any input parameters in the Params property. At design time, a developer can provide parameters using the Parameters editor. At runtime an application must access Params directly.
      • Call Prepare to bind the parameters.

If an application is only interested in the result set returned by a stored procedure, call StoredProc.Open or set its Active property to True.

See also: ParamByName, Params