July 1999
Intermediate to advanced
432 pages
13h 10m
English
Content preview from Access Database Design and Programming, Second EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Data Manipulation Languages
A DBMS must also provide a language designed to manipulate the data in a database. This language is called a database manipulation language, or DML. To the database programmer, however, the distinction between a DDL and a DML may be just a logical one, defined more by the purpose of the language than the syntax.
The Jet Data Manipulation Language
Example 7.2 is Jet DML code to add two records to the BOOKS table, set the index, and display the records.
Example 7-2. Jet DML Code Altering the BOOKS Table
' Data Manipulation Language example Dim rsBooks As Recordset ' Open the database Set dbLibrary = ws.OpenDatabase("d:\dao\library.mdb") ' Create a recordset for the BOOKS table Set rsBooks = dbLibrary.OpenRecordset("BOOKS") ' Add two records rsBooks.AddNewrsBooks!ISBN = "0-99-345678-0" rsBooks!Title = "DB Programming is Fun" rsBooks.UpdatersBooks.AddNewrsBooks!ISBN = "0-78-654321-0" rsBooks!Title = "DB Programming isn't Fun" rsBooks.Update' Set index rsBooks.Index= "ISBNIdx" ' Show the records rsBooks.MoveFirstMsgBox "ISBN: " & rsBooks!ISBN & " TI: " & rsBooks!Title rsBooks.MoveNextMsgBox "ISBN: " & rsBooks!ISBN & " TI: " & rsBooks!Title
As you can see even from this small example, the DML is designed to perform a variety of actions, such as:
Moving through the data in the database
Adding data to the database
Editing or updating data in the database
Deleting data from the database
Querying the data and returning those portions of the data that satisfy ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.