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 use of command Object?What are the various types of variables?
what are the Parts of ODBC?
What is the difference Between ADO and other data access objects?
Default cursor Type and LockEdit type in DAO?
What is understand in resource tracking?
What can you do with visual basic?
What is the use of ActiveX Documents?
What is the difference between COM and DCOM?
9 Answers 7 Seas, American Infoserv, Microsoft, SRMSCET,
What is a datacontrol?
How would you attach pictures in Treeview Control?
How does the following statements work? On Error Goto Err_Handler
To find the current recordposition in data control.