Method 4: Query Statements With Parameters

From InterBase

Go Up to DSQL Programming Methods

There are four steps to processing a SQL query statement string with placeholder parameters:

  1. Prepare an input XSQLDA to process a statement string’s parameters.
  2. Prepare an output XSQLDA to process the select-list items returned when the query is executed.
  3. Prepare the statement string and its parameters.
  4. Use a cursor to execute the statement using input parameter values from an input XSQLDA, and to retrieve select-list items from the output XSQLDA.


Advance To: