--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:

> >From IB documentation:
>
> isc_dsql_execute_immediate()
> prepares the DSQL statement specified in statement, executes it

once, and discards it.

> The statement must not be one that returns data (i.e., it must not

be a SELECT or EXECUTE PROCEDURE statement).

> If statement requires input parameter values (i.e., if it contains

parameter markers), these values must be supplied in

> the input XSQLDA, xsqlda.
>
> isc_dsql_exec_immed2()
> prepares the DSQL statement specified in statement, executes it

once, and discards it.

> The statement can return a single set of values (i.e, it can be an

EXECUTE PROCEDURE or singleton SELECT)

> in the output XSQLDA.
>
> Ivan

Thanks Ivan. I have read the docs but must have been too tired to
notice the "exec proc" comment. Good stuff, thanks for the help!!