Hi Franky,

> I still wonder what the difference is between ExecSql, ExecProc &
> Execute on a TIB_Storedproc, any idea?

I used to know, long ago...

But TIB_StoredProc is now deprecated for all I know. It's still there
because existing code may need it, but for anything new calling Stored
Procedures:

- use TIB_DSQL (and its Execute method) for executable SPs (SPs
returning at most one "row" of data).

- use TIB_Cursor/Query for selectable SPs (SPs that may return
multiple rows, and that contain a SUSPEND statement to give the
caller the opportunity to fetch the next row).


Greetings,
Paul Vinkenoog