Determining if API Calls Can Process a SQL Statement

From InterBase

Go Up to Writing an API Application to Process SQL Statements


Except as noted earlier in this chapter, DSQL functions can process most SQL statements. For example, DSQL can process data manipulation statements such as DELETE and INSERT, data definition statements such as ALTER TABLE and CREATE INDEX, and SELECT statements.

The following table lists SQL statements that cannot be processed by DSQL functions:

CLOSE

DECLARE CURSOR

DESCRIBE

EXECUTE

EXECUTE IMMEDIATE

FETCH

OPEN

PREPARE

These statements are used to process DSQL requests or to handle SQL cursors, which must always be specified when an application is written. Attempting to use them with DSQL results in run-time errors.

Advance To: