RE: [DUG] ADO - NextRecordSet.

[Stephen Bertram]

Myles

 

It works in the same way with TADOStoredProc, in fact and TADOCustomDataset descendent.  The key ingredient (which escaped me for several frustrating hours) is that NextRecordSet returns a RecordSet which is not an object in its own right, but a pointer to an internal structure in the TADODataset.

 

To utilise the record set it must be assigned to a TADODataset created elsewhere.  Once you've done that everything is straightforward.

 

Stephen

 

 

-----Original Message-----
From: Myles Penlington [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 March 2004 11:01 a.m.
To: 'NZ Borland Developers Group - Delphi List'
Subject: RE: [DUG] ADO - NextRecordSet.

Thanks.

Nice to know someone has it working. In our case we are using D7.

Will give it a try with code like that. We are using TADOStoredProc, so maybe that is an issue (but it should not be looking at the code)

 

Myles.

 

-----Original Message-----
From: Stephen Bertram [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 March 2004 10:54
To: NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] ADO - NextRecordSet.

Myles

 

We use NextRecordSet with the following code under Delphi 5

 

      var

        RecCount : Integer;

        dsBkgLn : TADODataSet; 

        qryBL : TADOQuery;

      begin

        ...

        dsBkgLn := TADODataSet.Create(nil);
        dsBkgLn.Recordset := qryBL.NextRecordset(RecCount);
        ....

 

Stephen

-----Original Message-----
From: Myles Penlington [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 March 2004 10:23 a.m.
To: '[EMAIL PROTECTED]'
Subject: [DUG] ADO - NextRecordSet.

Hi, We are trying to use the multiple recordset return function under ADO, but have not had any luck getting it to work under delphi - works fine via straight ADO/_javascript_ etc.

 

Has any body used this under Delphi and got it to work?

 

Thanks

Myles.

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This communication contains information that is confidential and the copyright of ensynergy Limited or a third party.

If you are not the intended recipient of this communication please delete and destroy all copies and telephone ensynergy Limited on +64 9 3551591 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of ensynergy Limited.

Any views expressed in this communication are those of the individual sender, except where the sender specifically states them to be the views of ensynergy Limited.

Except as required by law, ensynergy Limited does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This communication contains information that is confidential and the copyright of ensynergy Limited or a third party.

If you are not the intended recipient of this communication please delete and destroy all copies and telephone ensynergy Limited on +64 9 3551591 immediately. If you are the intended recipient of this communication you should not copy, disclose or distribute this communication without the authority of ensynergy Limited.

Any views expressed in this communication are those of the individual sender, except where the sender specifically states them to be the views of ensynergy Limited.

Except as required by law, ensynergy Limited does not represent, warrant and/or guarantee that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.

_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi