Interested to Buy Any Domain ? << Click Here >> for more details...
what are the Advantages of disconnected recordsets
- 1 Answers
- 10799 Views
- I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How would you create properties in ActiveX Control?
What is a toolbox in visual basic?
Is visualvm free?
Whether HTML supports multimedia: and document links?
Difference between DDE and OLE.
What is activex control in vb?
What is the default workspace?
Which method is preferred to save data like database to the disk?
How would you find out the value property in Slider Bar Control?
How do I play MID, WAV or other multimedia files?
Explain Types of DBCombo boxes?
How many File System Controls are there ? Explain.
What language does visual basic use?
what are the Types of LockEdits in RDO?
which property used to add a menus at runtime?
