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

Function procedures - vbscript, This is a series of VBScript statements enc...

This is a series of VBScript statements enclosed through the Function & End Function statements. A Function procedure is same to a Sub procedure, however can also return a value. T

Runtime proggramming, i have a database i want mange it network and i want ...

i have a database i want mange it network and i want write it with vb.net so how i can do this

Enabling odbc, Enabling ODBC: 1. Select the control panel, programs, s...

Enabling ODBC: 1. Select the control panel, programs, setting and then ODBC32 2. Double click on the ODBC32 3. The Settings for an operating system will take place. 4

If - else statement, A variation on the If...Then...Else statement lets you...

A variation on the If...Then...Else statement lets you to choose from various alternatives. By adding up Else If clauses expands the functionality of the If...Then...Else statement

Fixed length strings, Fixed length strings: The Fixed length strings ar...

Fixed length strings: The Fixed length strings are declared by identifying the size of the string. For illustration to give a length of 20 for the string place, the declarati

Dialog based application, Dialog Based Application: (A) Dialog Based ...

Dialog Based Application: (A) Dialog Based Application to demonstrate Animate Control: 1. Build a dialog based application. 2. Design the dialog as shown. 3. Place

Arrays, I need to design a logic for a program that allows a user to enter ...

I need to design a logic for a program that allows a user to enter 15 numbers, then displays each number and its difference from the numeric average of the numbers entered

Infomation system, what are the things that information system can do and t...

what are the things that information system can do and their limitations?

Displaying the file without scrolling - document class, Displaying the file...

Displaying the file Without Scrolling: To display a file follow the steps as shown below: 1. Generate a SDI application. 2. Type the coding as shown in the Serialize els

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