what are the types of Recordsets?
Answer / mathangi
Here are the five types of recordsets:
• Table-type Recordset
Basically a complete table from a database.
• Dynaset-type Recordset
The result of a query that can have updatable records. It
can contain fields from one or more tables in a database.
• Snapshot-type Recordset
A read-only set of records that you can use to find data or
generate reports.
• Forward-only-type Recordset
Identical to a snapshot except that no cursor is provided.
• Dynamic-type Recordset
A query result set from one or more base tables in which you
can add, change, or delete records from a row-returning
query. Further, records other users add, delete, or edit in
the base tables also appear in your Recordset.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the Advantage of ActiveX Dll over Active Exe?
How to find the current record position in data control?
which property is used to change to some value to access a identity column in datacontrols?
What do you mean by ADO?
What are the different cursor types that can we create using ADO Recordset? Difference between these cursor types?
Types of LockEdits in RDO.
Dim x, y as integer. What is x and y data type?
What is the difference between Msgbox Statement and MsgboxQ function?
What is the difference between a property a method and an event? Give an example of each.
Which method is used to write context Into file?
what is the difference between ADO and RDO in vb
what is different from edit and updates?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)