Executing a query
Go Up to Working with Queries
After you specify a SQL statement in the SQL property and set any parameters for the query, you can execute the query. When a query is executed, the server receives and processes SQL statements from your application. If the query is against local tables, the SQL engine processes the SQL statement and, for a
SELECT query, returns data to the application.
- Note: Before you execute a query for the first time, you may want to call the
Preparemethod to improve query performance. Prepare initializes the database server, each of which allocates system resources for the query. For more information about preparing a query, see Preparing a query.
The following sections describe executing both static and dynamic SQL statements at design time and at runtime.