Answer Posted / guest

A disconnected Recordset, as its name implies, is a
Recordset that lacks a connection. This may seem a bit
confusing at first - how can a Recordset lack a connection
to a data store?
- but will hopefully become more clear as the article
progresses.

seen that a Recordset that does not have a database
connection can be very useful as a tool in your
programming. It can save you time and effort and make your
code more scalable.

In order to create a disconnected Recordset two Recordset
properties must be set appropriately.It is a requirement
that the CursorLocation property is set to adUseClient and
the LockType property is set to adLockBatchOptimistic. Note
that the CursorType will default to adUseStatic
if we don't explicitly state that it should be set to
adUseClient.) i.e

rst.LockType = adLockBatchOptimistic
rst.CursorLocation = adUseClient

However, we've recently discovered that these steps aren't
necessary. VB automatically assigns batch optimistic
locking to newly created, connectionless recordsets. And,
of course, without a connection, a recordset can't have any
other cursor but a client-side one. To create one of these
structures, then, the only thing you need do is create the
object variable instance. After that, you can simply begin
adding fields to the construct.

To add fields, you use the Fields collection's Append
method. This method requires two parameters
, the field name and the field data type. So, to create a
connectionless recordset with two fields,you'd use code
similar to:

Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset

rst.Fields.Append "CustID", adVarChar
rst.Fields.Append "CustName", adVarChar

Additional, optional Append method parameters include
DefinedSize and Attrib. The DefinedSize
argument takes the size of the field. Fill the Attrib
parameter with constants that define additional field
characteristics, such as whether it will allow null values
or is updatable.
Since, in our technique, we want the fields to mirror the
structure of the original recordset, we'll simply use
existing values for these parameters.

Disconnected Recordsets, first available with ADO 2.0, are
the most commonly used mechanism to retrieve a Recordset
and open a connection for only the necessary amount of
time, thus increasing scalability. They are call
disconnected because the connection to the database is
closed.
The collections, properties, and methods of a disconnected
Recordset are still available even though the connection is
closed. This frees up server resources, given that the
number of open connections is limited and database locking
is a non-issue.

Difference between Linked Object and Embedded Object?

2327

---

Which property of textbox cannot be changed at runtime. What is the max size of textbox?

1068

---

Recordset object consists what?

2164

---

How would you navigate between one document to another document

1708

---

How come I get a "No Current Record" error when I use a a Data Control on an empty table?

1583

---

Specify technical & functional architecture of your last 2 projects.

2119

---

What is dao in visual basic?

1007

---

Through which protocol OLEDB components are interfaced?

2082

---

How can you Navigate from the DHTML application to another DHTML application? .

2235

---

I'm getting error message "Reserved Error [-nnnn] ("There is no message for this error")" from Jet Engine 2.0.Why?

1605

---

What is difference between datagrid and flexgrid?

14124

---

How do I dial a phone number without using the MSCOMM VBX?

2096

---

What are the uses of List View Control?

1966

---

VB ActiveX: Create a "drivelist"(D1) box, a "folderlistbox"(FLD1) that changes whenever D1 is changed , and a "FilelistBox"(FIL1) that is populated with the file lists under the selected directory in (D1).The file selected is stored in a variable "filename" along with the path. Question: How to use this activeX control in VC++ to get the selected filename?

2100

---

What is controls in vb?

1052

---