Thanks Paul

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

Franky

_____

Van: Paul Vinkenoog [mailto:paul@...]
Verzonden: dinsdag 22 juni 2004 15:13
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] TIB_Storedproc - ExecSql, Execute & ExecProc
methods


Hi Franky,

> I've made a Stored procedure which returns records when i execute
> it in ibexpert, no problem there.

If it returns records, then it's a so-called selectable stored
procedure. That is, you use SELECT to retrieve those rows of values.

> But from Delphi, using a TIB_Storedproc component i never get any
> records, although i've put the property StoredProcForSelect to True.

Just set up a TIB_Query (or TIB_Cursor if you don't need buffering)
with an SQL like:

select <field list> from MyStoredProc

and use it like any other query. (Well, except that you can't insert
or update.)


Greetings,
Paul Vinkenoog



________________________________________________________________________
___
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 !




Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129b9qaac/M=298184.5022502.6152625.3001176/
D=groups/S=1705007183:HM/EXP=1087996434/A=2164339/R=0/SIG=11e2d64in/*htt
p://www.netflix.com/Default?mqso=60183348>

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=group
s/S=:HM/A=2164339/rand=476184781>

_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

* To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com
<mailto:IBObjects-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




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