RAD Studio VCL Reference
TMtsDataModule.AS_Execute Method

AS_Executes the query or stored procedure bound to a specified provider.

procedure AS_Execute(const ProviderName: WideString; const CommandText: WideString; var Params: OleVariant; var OwnerData: OleVariant); safecall;
__fastcall AS_Execute(const BSTR ProviderName, const BSTR CommandText, OleVariant Params, OleVariant OwnerData);

Use AS_Execute to pass an execute command to a remote provider, using a specified set of parameters. AS_Execute calls the AS_Execute method of the specified provider after assigning any parameters. Output parameters that result from executing a query or stored procedure are returned in the Params parameter.

Note: AS_AS_Execute should only be called for a provider whose dataset represents a query or stored procedure that does not return a cursor.
The ProviderName parameter specifies the name of the provider component associated with the query or stored procedure.  

CommandText specifies an optional SQL statement that replaces the SQL of the provider's query, or the name of a table or stored procedure that replaces the provider's underlying database table or stored procedure. This parameter is ignored if the Options property does not include poAllowCommandText. 

The Params parameter encodes any parameters expected by the query or stored procedure and returns any output parameters. To create a properly encoded value for Params from a TParams object, use the PackageParams method. 

The OwnerData parameter contains custom information that appears as an argument to the provider's BeforeAS_Execute and AfterAS_Execute event handlers. This information originates in a client dataset's BeforeAS_Execute event handler. The value returned in OwnerData is passed to the client dataset's AfterAS_Execute event handler.

Note: Applications can only call the protected AS_AS_Execute method using the TRemoteDataModule interface. To execute a dataset in code from the application server, use the dataset component directly.


Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!