Programming Language Extension Using Structured Query Language for Database Access

Authors: Chapman Eze Nnadozie

Abstract:

Relational databases constitute a very vital tool for the effective management and administration of both personal and organizational data. Data access ranges from a single user database management software to a more complex distributed server system. This paper intends to appraise the use a programming language extension like structured query language (SQL) to establish links to a relational database (Microsoft Access 2013) using Visual C++ 9 programming language environment. The methodology used involves the creation of tables to form a database using Microsoft Access 2013, which is Object Linking and Embedding (OLE) database compliant. The SQL command is used to query the tables in the database for easy extraction of expected records inside the visual C++ environment. The findings of this paper reveal that records can easily be accessed and manipulated to filter exactly what the user wants, such as retrieval of records with specified criteria, updating of records, and deletion of part or the whole records in a table.

Keywords: Data access, database, database management system, OLE, programming language, records, relational database, software, SQL, table.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1340408

References:

[1] Williams, M., Bennett, D. et al. (2002). Microsoft Visual C++ 6 Unleashed. U.S.A.: Sams Publishing.
[2] O’Leary, T. J. and O’Leary, L. I. (2007). Computing Essentials. New York: The McGraw-Hill Companies.
[3] Chapman, D. (2001). Sams Teach Yourself Visual C++ 6 in 21 Days. U.S.A.: Sams Publishing.
[4] Lester, C. S. et al. (1999). Database Programming with Visual J++. U.S.A.: Que Corporation.
[5] Din, Akeel I. (2007). Structured Query Language (SQL) A practical approach.
[6] Dietel, P. J. and Dietel, H. M. (2010). C++ How to Program –Sixth Edition. New Jersey: Pearson Prentice Hall.