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 instantiating?

0 Answers  


How would you access objects created in ActiveX Exe and ActiveX D1T ?

0 Answers  


How to down load image properties.

0 Answers  


What are the rules which should be followed while naming a variable in VB?

0 Answers  


What are constructors and destructors?

1 Answers  






How would you create properties by using class Builder Wizard?

0 Answers  


What is ActiveX Document?

0 Answers   HCL,


How can you filter out specific type of file using file system controls?

0 Answers  


What is the use of Data Form Wizard?

0 Answers  


What kind of components can you use as DCOM servers?

1 Answers   Hudson,


Does VB support object-oriented concepts? Explain..

3 Answers  


What is the max size allowed for Msgbox Prompt and Input Box?

5 Answers   AZTEC, IBM,


Categories