what are the types of Recordsets?

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


Please Help Members By Posting Answers For Below Questions

To populate a single column value which dbcontrols you to use?

1566


Explain about literals?

553


What are the uses of List View Control?

1436


To validate a range of values for a property whenever the property values changes,which type of property procedure you use?

1428


How can I access a record by record number?

1043






Explain Types of DBCombo boxes?

594


What is the use of debug Window?

1540


Is it possible to Manipulate data through flexgrid? Explain.

2059


How would you create Visual basic Document file?

1892


____ is the difference between Listindex and Tab index.

1298


What are 3 main differences between flexgrid control and dbgrid control?

1693


How would you create Visual basic Document file?

1377


how a multiple routing works ?

2295


Is it possible to call oracle database through ADO control or Object?

1363


What is the use of Data Form Wizard?

1542