This component allows a command in code such as SQL to be run on a database. It can be used to execute DML statements such as INSERT, DELETE, DROP, etc.
The CommandText property provides the facility to add SQL commands and there is a miniature SQL editor available by clicking on the dieresis. A quick way to add SQL code is to copy and paste it from a database application such as Access, which generates it from the QBE process (though it is not standard SQL).
The time in seconds that the component will wait until execution is considered a failure.
The type of command corresponds to the type of command in the CommandText.
Set the ADO connection string, as for the DataConnection component. Double click on the component icon to open a field list box and right click inside this box. Choose an option to add fields and then drag the fields onto the form in the order required.