🚀 go-pugleaf

1. Use client-side cursor.
2. Use TADOConnection and set StoredProc.Connection = NULL before closing
connection.

 ADOStoredProc1->Active = true;
 ADOStoredProc1->Connection = NULL;
 ADOConnection1->Connected = false;

Recordset.Clone() clones cursor (affects current position, MoveBy(), Next(),
Prior() etc.)  but recordset stays the same.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Paul Cheetham" <PAC.News@dsl.pipex.com> �������/�������� � ��������
���������: news:MPG.1b9c0dd99db2ead2989691@Newsgroups.Borland.com...
>
> Hi,
>
> I am using a TADOStoredProc component to call a stored procedure on an
> MS SQL server and return a data set.
> I was expecting the dataset to be returned and held in memory, meaning I
> could close the connection, and then read the data as required.
>
> It seems though, that if I close the connection, my data goes with it!
> I have tried creating a new dataset (TCustomADODataSet) and using the
> Clone function - I expected this to copy the data but it appears not to.
>
> Can anyone tell me if it is possible to copy a datset into memory in
> some way, as it makes things so much neater.
>
>
> Thankyou.
>
>
>
> -- 
> Paul Cheetham
>
> "There are 10 types of people in the world - those that understand
> Binary, and those that don't."