Subject RE: [IBO] TIB_Storedproc - ExecSql, Execute & ExecProc methods
Author Franky Brandt
Thanks Paul

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



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

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.)

Paul Vinkenoog

IB Objects - direct, complete, custom connectivity to Firebird or
without the need for BDE, ODBC or any other layer.
___ - your IBO community resource for Tech Info
keyword-searchable FAQ, community code contributions and more !

Yahoo! Groups Sponsor
click here



Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to:

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

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