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

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

Indexing - visual basic, Indexing: In libraries, the card catalog is t...

Indexing: In libraries, the card catalog is the index. The three indices are used in the library. The Author, Subject and title are the 3 indices. Each index is relative. The

Messages - visual basic programming, MESSAGES The Windows-based applica...

MESSAGES The Windows-based applications do not make explicit function calls to acquire input. They wait for the system to pass the input to them. The system passes input to the

Conditional statements, You can control the flow of your script with condit...

You can control the flow of your script with conditional statements & looping statements.  By using conditional statements, you can write VBScript code which makes decisions and re

Variant type - visual basic, Variant Type: If no data type is related ...

Variant Type: If no data type is related with the VB variables, it takes the default variant type. The variable x will be of the variant type when the two declarations below a

Application to count the number of possible triangles, A triangle is equila...

A triangle is equilateral if all three sides are equal, isosceles if any two (but no more than two) sides are equal, and scalene if no two sides are equal. A triangle will be input

Illustration of mdi application using a project, ILLUSTRATION OF MDI APPLIC...

ILLUSTRATION OF MDI APPLICATION USING A PROJECT 1. Choose the MDI option while generating the project by using the Appwizard. 2. Add the WM_LBUTTONDOWN message for the view

ADO.net architecture, write a detailed account on ADO.net architecture.

write a detailed account on ADO.net architecture.

Running statements if a condition is true, To run only one statement while ...

To run only one statement while a condition is True, employ the single-line syntax for the If...Then...Else statement. The following instance shows the single-line syntax. Notice t

Associating toolbars for the menu - visual basic, Associating Toolbars for ...

Associating Toolbars for the menu: 1. Insert the tool bar control to your form. 2. Now follow the steps to append the tool bar control to your form. 3. Then, Right Click

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