Thanks a lot Paul for you help.

Rgds

Peter

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


Hello Peter,

> 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 ?

It works the same, just set the SQL property:

execute procedure MyProc :ThisParam :ThatParam

After preparation, you can set the params just like you do for any
dataset, with Params[i] or ParamByName( 'ThisOrThatParam' ).
BTW, if you use ParamByName a prepare will be done automatically if
necessary.

Then you call MyDSQL.Execute. If the SP returns any values, they will
be available via MyDSQL.Fields[i] and MyDSQL.FieldByName( 'Name' ).


Greetings,
Paul


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]