Databases Reference
In-Depth Information
The User object represents a user account with particular access permissions.
The Group object represents a group of user accounts that have common access permissions
in a particular workspace.
The Error object stores information about an error that occurred during a DAO operation.
When more than one error occurs during a single DAO operation, each individual error
is represented by a separate Error object.
7.9
SUMMARY
This chapter has focused on static operations to a database — static meaning that no elements of
the database were altered and no new elements were added to the database. Static operations to a
database are relatively easy to code because the elements in the database never change their location.
They are simply read from their existing locations within the database file, and the database file
structure remains unchanged.
Applications of any sophistication, however, will be dynamic in nature, meaning that elements
within the database will be added, deleted, or altered depending upon the coding algorithm applied
to the database. Performing dynamic actions on a database poses special coding challenges because
the number of elements that an action is to be performed on is constantly changing as items are
added, altered, and deleted from the database. Algorithms that address the challenges of dynamic
coding structures on databases will be covered in detail in Chapter 8.
The concepts of using both DAO and SQL to access database information were introduced in
this section and will be covered more in more detail in the subsequent chapter.
