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 Difference between listbox and combo box?

2 Answers  


What is DAO?

2 Answers  


What is the use of Hyperlink control for DHTML applications?

0 Answers  


What is the different between Microsoft ODBC Driver and Oracle OBDC Driver?

1 Answers  


How to use hyperlink?

0 Answers  






Difference between DDE and OLE.

0 Answers  


What is the use of Tabledef?

0 Answers  


Is the Variant type slower than using other variable types?

0 Answers  


What is the use of OLE?

0 Answers   IBM,


what is the Difference between listbox and combo box?

5 Answers   TCS,


How do you create a form in visual basic?

0 Answers  


What is ActiveX Control?

1 Answers   Infosys,


Categories