Executing the SQL Statements
Go Up to Using Multiple Update Objects Index
Attention: The Borland Database Engine (BDE) has been deprecated, so it will not be enhanced. For instance, BDE will never have Unicode support. You should not undertake new development with BDE. Consider migrating your existing database applications from BDE to dbExpress.
When you use multiple update objects, you do not associate the update objects with a dataset by setting its UpdateObject property. As a result, the appropriate statements are not automatically executed when you apply updates. Instead, you must explicitly invoke the update object in code.
There are two ways to invoke the update object. Which way you choose depends on whether the SQL statement uses parameters to represent field values:
- If the SQL statement to execute uses parameters, call the Apply method.
- If the SQL statement to execute does not use parameters, it is more efficient to call the ExecSQL method.
Note: If the SQL statement uses parameters other than the built-in types (for the original and updated field values), you must manually supply parameter values instead of relying on the parameter substitution provided by the Apply method. See Using an Update Component's Query Property for information on manually providing parameter values.