Subject Re: [IBO] TIB_Storedproc - ExecSql, Execute & ExecProc methods
Author Dmitry Beloshistov
Hello, Franky!
You wrote to <IBObjects@yahoogroups.com> on Tue, 22 Jun 2004 15:00:55 +0200:

FB> I've made a Stored procedure which returns records when i execute it
FB> in ibexpert, no problem there.
FB> But from Delphi, using a TIB_Storedproc component i never get any
[Sorry, skipped]
FB> I tried using ExecSql, Execute & ExecProc methods(which i don't know
FB> the differences of) but all 3 return 0 records.

FB> Any ideas?

with IB_Query1 do
begin
close; sql.text:='select * from MySPName(?Param1)';
Prepare;
ParamValues['Param1']:=1234;
Open;
end;

WBR, Dmitry Beloshistov AKA [-=BDS=-]