Re: About NextRecordSet

If you know what recordsets are going to be returned you could..

var
Table1 : _RecordSet;
Table2 : _RecordSet;
iDummy :Integer;
begin
Table1 := asp.NextRecordSet(iDummy);
{do something with Table1}
Table2 := asp.NextRecordSet(iDummy);
{do something with Table2}
end;

Good luck,
krf

"Tuðrul HELVACI" <king_of_delphi@xxxxxxxxxxx> wrote in message
news:429546bd@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi All,
>
> i am using SQL Server and Delphi 7 and i have a stored procedure that
> returns multiple resultsets.When i using TADOStoredProc's NextRecordset
> method my current recordset was changed. At the end of the
> NextRecordSet calls my TADOStoredProc object has point a last
> recordset.Is it possible to point first recorset again ? For example:
>
> my stored procedure looks like following;
>
> Create Procedure MyProc
> As
> Select * from Table_A --first recordset
> select * from Table_B --second recordset
> select * from Table_C --third recordset
>
> and code here..
>
> asp : TADOStoredProc;
>
> var
> iDummy : Integer;
> begin
> asp.NextRecordSet(iDummy); // my object has point second recordset now
> asp.NextRecordSet(iDummy); // my object has point third recordset now
>
> {
> What code must i write here to go back first recordset ???
> Is it possible ? I dont want to Close/Open again.
> }
> end;
>
> Sincerely


.

Relevant Pages

  • Re: Recordsetclone mistake
    ... > This continious form is linked with Table1 to be able to ... > Row Source is Table2. ... So the form knows about them, but its recordset ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)
  • Speed of Code
    ... corresponding entries in Table2 and pull a couple of fields from Table2 into ... Table1 where those ITEMS are equal and the date is of the latest date. ... How I do this now is open table 1 as a recordset, ... When I reach the end of Table2 I use a DO LOOP to start table 1 at ...
    (microsoft.public.access.formscoding)
  • Re: Is there a solution to this?
    ... > Lets say I have two tables, table1 and table2 that have a one to one ... > The resulting recordset can be modified but if new records are added to ... then it gives a write conflict. ...
    (microsoft.public.access.adp.sqlserver)
  • Is there a solution to this?
    ... Lets say I have two tables, table1 and table2 that have a one to one relationship ... The resulting recordset can be modified but if new records are added to this, then it gives a write conflict. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Is there a solution to this?
    ... > Lets say I have two tables, table1 and table2 that have a one to one ... > number is the primary key and is numeric format. ... > The resulting recordset can be modified but if new records are added to ... then it gives a write conflict. ...
    (microsoft.public.access.adp.sqlserver)