How to store a recordset from TMSStoredProc?
Posted: Tue 06 Jun 2006 07:52
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.
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.