Tutorial Downloads .com

Home

Difference between Dynaset and Snapshot | VB Interview question

Difference between Dynaset and Snapshot

All Recordset objects are constructed using records (rows) and fields (columns). There are five types of Recordset objects:

Table-type Recordset ::
representation in code of a base table that you can use to add, change, or delete records from a single database table (Microsoft Jet workspaces only).

Dynaset-type Recordset ::
the result of a query that can have updatable records. A dynaset-type Recordset object is a dynamic set of records that you can use to add, change, or delete records from an underlying database table or tables. A dynaset-type Recordset object can contain fields from one or more tables in a database. This type corresponds to an ODBC keyset cursor.

Snapshot-type Recordset ::
a static copy of a set of records that you can use to find data or generate reports. A snapshot-type Recordset object can contain fields from one or more tables in a database but can't be updated. This type corresponds to an ODBC static cursor.

Forward-only-type Recordset::
identical to a snapshot except that no cursor is provided. You can only scroll forward through records. This improves performance in situations where you only need to make a single pass through a result set. This type corresponds to an ODBC forward-only cursor.

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. This type corresponds to an ODBC dynamic cursor (ODBCDirect workspaces only).
Difference Listindex and Tab index?

LIST INDEX::
Returns or sets theindex of the currently selected item in the control. Not available at design time.Default LIST INDEX IS -1 for ComboBox, DirListBox, and DriveListBox controls
TAB INDEX::
Returns or sets thetab order of most objects within their parent form. Visual Basic automatically renumbers the TabIndex of other controls to reflect insertions and deletions. You can make changes atdesign time using theProperties window or atrun time in code.The TabIndex property isn't affected by the ZOrder method.


Resource:
Posted By : Naina
On date : 07.25.08

Most used Visual Basic ( VB ) Tutorials

Visual Basic Tutorial ( Ebooks , PDF's )
Visual Basic 6 Tutorial Download Visual Basic.Net Practical Standards For Microsoft Visual Basic Microsoft Visual Basic Design Patterns
VB Interview Questions & Answers
differences between flexgrid control and dbgrid, at is difference between inprocess and out of process, What is a Component?How to register a component?What are the Control Categories Difference between Dynaset and Snapshot? Difference Declaration and Instantiation an object? What is a Type Library and what is it's purpose ? What is DBFailError?What is DBSqlPassThrough? .... etc... etc....
What is the max size allowed for Msgbox Prompt and Input Box | Visual basic Question
What is the max size allowed for Msgbox Prompt and Input Box in VB
Microsoft Visual Basic 2008 Step by Step tutorial
This is a VB tutorial book which describes Microsoft Visual Basic 2008 Step by Step
Difference between a function and a subroutine | VB Interview question
Difference between a function and a subroutine
Difference between listbox and combo box | VB Interview question
Difference between listbox and combo box
Diff types of Lock Types in Vb
Diff types of Lock Types
What are the three main differences between flexgrid control and dbgrid(Data bound Grid) control
What are the three main differences between flexgrid control and dbgrid(Data bound Grid) control
Advantage of ActiveX Dll over Active Exe
Advantage of ActiveX Dll over Active Exe
DIFF between Image and Picture box controls | VB Question
DIFF between Image and Picture box controls?
ActiveX and Types of ActiveX Components in VB
ActiveX and Types of ActiveX Components in VB
Difference between Dynaset and Snapshot | VB Interview question
Difference between Dynaset and Snapshot
What are the RDO Methods and Events in VB
What are the RDO Methods and Events
Difference Query unload and unload in form | VB Interview question
Difference Query unload and unload in form
What is meant by "Early Binding" and "Late Binding" Which is better | Visual basic
What is meant by "Early Binding" and "Late Binding"? Which is better?

Latest added Visual Basic ( VB ) Tutorials

Microsoft Visual Basic 2008 Step by Step tutorial
This is a VB tutorial book which describes Microsoft Visual Basic 2008 Step by Step
What are the RDO Methods and Events in VB
What are the RDO Methods and Events
Diff types of Lock Types in Vb
Diff types of Lock Types
What is the max size allowed for Msgbox Prompt and Input Box | Visual basic Question
What is the max size allowed for Msgbox Prompt and Input Box in VB
What is the purpose of the ClipControls property on a form or container | VB Question
What is the purpose of the ClipControls property on a form or container
What is the difference in passing values ByRef or ByVal to a procedure | VB Question
What is the difference in passing values ByRef or ByVal to a procedure
Describe and In Process vs. Out of Process component. Which is faster | VB Question
Describe and In Process vs. Out of Process component. Which is faster
different compatibility types when creating a COM component | VB Interview Question
different compatibility types when creating a COM component
Name the four different cursor and locking types in ADO and describe them briefly
Name the four different cursor and locking types in ADO and describe them briefly
What are binary and project compatibility | VB Question
What are binary and project compatibility