Subject | Re: [IBO] TIB_Storedproc - ExecSql, Execute & ExecProc methods |
---|---|
Author | Dmitry Beloshistov |
Post date | 2004-06-22T13:23:45Z |
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=-]
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=-]