Subject Re: [firebird-support] Re: Problem IBStoredProc
Author Dmitry Kuzmenko
Hello, Farshid!

>> > > //----------in delphi
>> > > IBStoredProc1.StoredProcName := 'SP';
>> > > IBStoredProc1.ParamByName('TLek').AsString := 'mb';
>> > > IBStoredProc1.ExecProc;

IBStoredProc is not a DataSet, while it is inherited from DataSet,
thus it can't return set of rows.

It can execute only procedures, that does not coniain suspend,
because it executes SPs only as

If you wrote selective procedure (with suspend inside),
you must call it via
select * from MYPROC

and you also must run it via IBQuery, IBSQL, or IBDataSet (SelectSQL).

p.s. well, you can use IBStoredProc with selective procedure,
but running IBStoredProc.ExecProc will give you only first row
that procedure returns.

Dmitry Kuzmenko,