Re-executing a Query Statement String With Parameters
From InterBase
Go Up to Method 4: Query Statements With Parameters
Once a query statement string with parameters is prepared, it can be used as often as required in an application. Before each subsequent use, the input XSQLDA can be supplied with new parameter and NULL indicator data. The cursor must be closed and reopened before processing can occur.
- To provide new parameters to the input
XSQLDA, follow steps 3 to 5 of Preparing a Query Statement String with Parameters. - To provide new information to the output
XSQLDA, follow steps 6 to 8 of Preparing a Query Statement String with Parameters. - To reopen a cursor and process select-list items, repeat steps 2 to 4 of Executing a Query Statement String Within the Context of a Cursor.