DSQL Programming Methods

From InterBase

Go Up to Working with Dynamic SQL


There are four possible DSQL programming methods for handling a SQL statement string. The best method for processing a string depends on the type of SQL statement in the string, and whether or not it contains placeholders for parameters. The following decision table explains how to determine the appropriate processing method for a given string:

SQL Statement Strings and Recommended Processing Methods
Is it a query? Does it have placeholders? Processing method to use:

No

No

Method 1

No

Yes

Method 2

Yes

No

Method 3

Yes

Yes

Method 4

Topics

Advance To: