Write a BeforeExecute event handler to send custom information to the client dataset's provider. BeforeExecute is part of the mechanism by which a client dataset and a provider communicate information when explicitly executing an SQL command by the provider's dataset. When working with a provider on a stateless application server, this mechanism allows the client dataset and the provider to communicate persistent state information. 

When the application calls the client dataset's Execute method, the following events occur: 

1.The client dataset receives a BeforeExecute event, where it can encode custom information into an OleVariant that is passed to the provider as the OwnerData parameter. 

2.The provider receives a BeforeExecute event, where it can respond to or change that information before it executes the query or stored procedure.  

3.The provider executes the appropriate command (either the command supplied by the CommandText property, or the command associated with a dataset such as a query or stored procedure). 

4.The provider receives an AfterExecute event, where it can encode custom information into its OwnerData parameter or respond to information from the BeforeExecute event handler. 

5.The client dataset unpacks any output parameters from the provider into the Params property and then receives an AfterExecute event, where it can respond to the custom information returned by the provider's AfterExecute event handler. 

Execute 

AS_Execute 

Execute 

beforeexecute 

AfterExecute 

CommandText 

Communicating with the Client Dataset