what are the Advantages of disconnected recordsets

Question Posted / guest

1 Answers
10015 Views
I also Faced
E-Mail Answers

what are the Advantages of disconnected recordsets..

Answer / 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.

Is This Answer Correct ?

6 Yes

1 No

Post New Answer