Answer Posted / 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 |
Post New Answer View All Answers
What is the use of NEW Keyword? Explain.
To.set the command button for ESC ___ Property has to be changed.
What is ado data control in vb?
___,___ arguments will be used to run a executable program in shell function
What is data binding in vb net?
How many types of API functions are available in VB?
What is the use of Tabledef?
How would you access objects created in ActiveX Exe and ActiveX D1T ?
Types of LockEdits in RDO.
what is the Difference between Recordset and Querydef?
How can you Navigate from the DHTML application to another DHTML application? .
Can you create a tabletype of recordset in Jet - connected ODBC dbengine?
How do I call a DLL?
what are the Default cursor Type and LockEdit type in DAO?
What are forms in visual basic?