At 01:32 PM 16/11/2003 +0000, you wrote:

>Thanks Paul
>
>That's a great help, I'm doing this for my own experience, just to learn
>how to use these particular components correctly.
>I believe I can assign the params to a TIB_DSQL , but how do I call my
>stored procedure from here ?, previously I have only used an TIB_Stored
>procedure ?

SQL: EXECUTE PROCEDURE MyProc(:Param1,:Param2, ...) Much faster and
easier than TIB_StoredProc. Call Execute to errrrm execute it; and read
returning values in the Fields[] array.

Can't use TIB_SQL for selectable SPs though, use a TIB_Cursor or TIB_Query
for those:
SQL: SELECT Field1, Field2, .... FROM MyProc(:Param1,:Param2, ...)
Call Open to execute it.

Chew TIB_StoredProc into a tight, waddy ball and spit it out of a high-rise
building.

HB