Record set - database applications, Visual Basic Programming

Record Set:

The record set presents the records in a base table or the records retrieved due to the query. The record set falls into 3 classes. These are table type record sets, dyna set & the snap shot type record sets.

(i)Table Type Record Sets:

The Table type record sets present a base table in the Microsoft Jet data base.

(ii) Dyna Set Type Record Sets:

The Dyna set type record sets are the resulting of a query.

(iii)Snap shot Type Record Sets:

The Snap shot type record sets presents a static copy of the records.

(iv) Data Source:

The Data source is a specific illustration made up of the 4 components.

  • Database which contains the data
  • A DBMS
  • The Operating system and the environment where the data resides
  • The network connection which permits access to the data source.

The database associated projects are made up of the MFC database classes. The ODBC driver manager uses the driver interacts with the database as shown in figure.

79_working of database application.png

Figure: Working of a Database Application

Posted Date: 10/10/2012 2:48:01 AM | Location : United States







Related Discussions:- Record set - database applications, Assignment Help, Ask Question on Record set - database applications, Get Answer, Expert's Help, Record set - database applications Discussions

Write discussion on Record set - database applications
Your posts are moderated
Related Questions
INTRINSIC CONTROLS   The Intrinsic controls are the built-in controls. Few of the controls are Combo box, Check box, Command Button, Label etc. The controls have properties re

CONTEXT-SENSITIVE HELP   The Context-sensitive help gives online help for the circumstances which is associated with that state. The Context-sensitive help can be implemented

CLASS WIZARD The Class wizard shown in figure is a tool to handle the message handlers for objects, to define the member variables. Figure: Class Wizard

DIALOG BOXES IN VB The two dialog boxes, namely, the message box and the input box are usually used in the Visual Basic. The message box is used for displaying the messages to

DDX - Dialog Data Exchange: The Data members can be related with specific controls in the dialog box. When the dialog box is displayed, the DDX will transfer the values into t

Methods: VBScript Dictionary Object Method D escription Add Method Adds a key, item pair. Exists Method

Using Loops to Repeat Code Looping let you to run a group of statements repeatedly. Some loops repeat statements till a condition are False; others repeat statements till a con

Message Routing: The system posts the messages to a first-in, first-out queue known as the message queue or it sends the messages directly to a window procedure. The Messages


Write an event procedure to automate the billing system of a supermarket. Give the details of database tables, forms, controls and menu design (if any). Make assumptions, wherever