Record set - database applications, Visual Basic Programming

Assignment Help:

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


Related Discussions:- Record set - database applications

Explain class module and standard module, Difference between Class Module a...

Difference between Class Module and Standard Module? Standard module: -This place for variable declarations,procedures etc.& it can accessed these procedures in whereve

Drawing, #questiontypes of lines and how to draw

#questiontypes of lines and how to draw

Objective of vb script, The objective of this unit is to describe the basic...

The objective of this unit is to describe the basics of VBScript. After completing this unit, you will be capable to write code for Web pages via VBScript. You will be able to unde

Constant naming conventions, Earlier versions of VBScript had no mechanism ...

Earlier versions of VBScript had no mechanism for making user-defined constants. Constants, if utilized, were implemented as variables & distinguished from other variables by using

Develop a web page for accepting information regarding stock, Develop a web...

Develop a web page that is used for accepting information regarding stocks. Make sure the form carry out the possible validations. The simple instance code below merely illustrates

Events - intrinsic contol, Events: The Controls are placed on a form a...

Events: The Controls are placed on a form and then to make them functional an "event procedure" is related with the control object. An event process is what happens in respons

Coding, Write an event procedure to automate the billing system of a superm...

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

Number property, Returns or sets a numeric value indicating an error. Numbe...

Returns or sets a numeric value indicating an error. Number is the Err object's default property. While returning user-defined error from an Automation object, set Err.Number throu

Create a visual basic application to play Hangman game, Create a Visual Bas...

Create a Visual Basic that allows a user to play a variation of Hangman. User Inputs The user types a letter into the textbox.   Functional Items 1. Read a

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd