Page 1 of 1

How to store a recordset from TMSStoredProc?

Posted: Tue 06 Jun 2006 07:52
by ilikegreentrafficlights
Hi i'm new to using SDAC,
How do i store a recordset that is returned from a stored proc without using the ADO objects?

I.e. Old code snippet
lRecordSet : _RecordSet;

fADOStoredProc.ExecProc;
lRecordSet := fADOStoredProc.RecordSet;


I can return a single variable using this

MSStoredProc1.ExecProc;
lReturnID := MSStoredProc1.Params.ParamByName('@RETURN_VALUE').Value;

But how to store a recordset?
Thanks.

Posted: Tue 06 Jun 2006 08:53
by Jackson
TMSStoredProc is descendant of TDataSet and dataset returned by ExecProc method is placed in the TMSStoredProc object itself.