what are the types of Recordsets?



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

Post New Answer

More Visual Basic Interview Questions

What is the use of command Object?What are the various types of variables?

0 Answers  


what are the Parts of ODBC?

0 Answers  


What is the difference Between ADO and other data access objects?

1 Answers  


Default cursor Type and LockEdit type in DAO?

1 Answers  


What is understand in resource tracking?

0 Answers  






What can you do with visual basic?

0 Answers  


What is the use of ActiveX Documents?

0 Answers  


What is the difference between COM and DCOM?

9 Answers   7 Seas, American Infoserv, Microsoft, SRMSCET,


What is a datacontrol?

1 Answers  


How would you attach pictures in Treeview Control?

1 Answers   HCL,


How does the following statements work? On Error Goto Err_Handler

2 Answers  


To find the current recordposition in data control.

0 Answers  


Categories