Queries for server developers

Go Up to Working with Queries

As a server developer you are already familiar with SQL and with the capabilities of your database server. To you a query is the SQL statement you use to access data. You know how to use and manipulate this statement and how to use optional parameters with it.

The SQL statement and its parameters are the most important parts of a query component. The query component’s SQL property is used to provide the SQL statement to use for data access, and the component’s Params property is an optional array of parameters to bind into the query. However, a query component is much more than a SQL statement and its parameters. A query component is also the interface between your client application and the server.

A client application uses the properties and methods of a query component to manipulate a SQL statement and its parameters, to specify the database to query, to prepare and unprepare queries with parameters, and to execute the query. A query component’s methods communicates with the database server.

To learn more about using the SQL property to write a SQL statement, see Specifying the SQL statement to execute. To learn more about using parameters in your SQL statements, see Setting parameters. To learn about preparing a query, see Preparing a query, and to learn more about executing a query, see Executing a query.