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.
The following sections describe executing both static and dynamic SQL statements at design time and at runtime.