Disconnected recordsets are, as you said, client-side recordsets which do

not have active connection to the database. It means that records are copied

onto client-side into rs object(in memory or you can save disconnected

recordset on hard disk in ATG or XML format). And disconnected rs has those

records which were in the database at the time of this rs was

created(running sql query,opening table whatever).



If you update fields in disconnected rs, changes aren't visible in the

database until you synchronize rs with database. That means re-creating a

connection to the database.



Example of creating a disconnected recordset:

*****************

Set rs=Server.CreateObject("ADODB.Recordset")



'CursorLocation must be adUseClient

rs.CursorLocation = adUseClient



rs.Open "SELECT * FROM myTable",objConn,adOpenStatic,adLockReadOnly



'Disconnecting rs

Set rs.ActiveConnection = Nothing



'Now you can loop rs,manipulate data,save it on disk etc and you do not have

active connection to the database.

******************



This was just a scratch about these things. Check also ADO documentation at

http://www.microsoft.com/data

and this : http://support.microsoft.com/support/kb/articles/q289/5/31.ASP



Teemu Keiski

Internet Application Developer

Mansoft tietotekniikka Oy



-----Alkuperäinen viesti-----

Lähettäjä: Ajay [mailto:ajay_ndel@y...]

Lähetetty: 26. heinäkuuta 2001 0:29

Vastaanottaja: asp_discuss

Aihe: [asp_discuss] Disconnected Recordsets





Hi all,



I wanted  to understand the fundamentals of disconnected recordsets.

What do we mean by  disconnected recordsets.?

How do we create them?



If disconnected recordsets are stored at client side, then

How do we retrieve records.

The recordsets reside where? (Client's meory, Temp. files)?



I appreciate any help on this.



Thanks,

Ajay