Thank Helen

Oh omni-present one !

Can't wait for your book, do you have a date yet ?

Rgds

Peter

----- Original Message -----
From: Helen Borrie
To: IBObjects@yahoogroups.com
Sent: Sunday, November 16, 2003 1:42 PM
Subject: Re: [IBO] TIB_ROW


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



Yahoo! Groups Sponsor



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]