Errata


Print Print Icon

Submit your own errata for this product.


The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.


Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question



Version Location Description Submitted By Corrected
Printed Page xvi
changed "ora.com" to "oreilly.com" both times it appears

Anonymous  Sep 1997
Printed Page xvi

para. 2: the URL for updates now reads:

"http://www.oreilly.com/catalog/9781565922976/"

Anonymous  Nov 1998
Printed Page 6

changed the equation on line 3 to read:

(16,000,000 - 10,000) * 50 = 799 million characters

plus, in the next para., changed "megabytes" to "gigabytes"

Anonymous  Jan 1998
Printed Page 6
In the first sentence after the equation, changed "160 gigabytes" to

"1.6 gigabytes"

Anonymous  Apr 1999
Printed Page 7

In the second para under Deletion Anomalies, the sentence used to read:

Such a database is called...

It now reads:

Because a table describes a "relation", such a database is called...

Anonymous  Apr 1999
Printed Page 9
last line: changed "related" to "persistent"

Anonymous  Jan 1998
Printed Page 21
2nd line of "Key" entry changed "no longer a key" to "no

longer a superkey"

Anonymous  Sep 1997
Printed Page 29
item #5, line 1: changed "OK button" to "Create button"

Anonymous  Jan 1998
Printed Page 32
figure 3-9 is new.

Anonymous  Sep 1997
Printed Page 48
in both tables, changed "0-222-22222-2" to "0-111-22222-2"

Anonymous  Apr 1998
Printed Page 48
Changed the display from

{ISBN, PubPhone} and {PubPhone, PubName}
to

{ISBN, PageCount} and {PageCount, Price}

Anonymous  Mar 1999
Printed Page 59-60
The sample tables are not designated S and T as they are

referred to in the text - very minor detail, but labeling the tables
would increase reader-friendliness.

Anonymous 
Printed Page 62
figure 5-7 is also new.

Anonymous  Sep 1997
Printed Page 66
line between tables, and next-to-last line on page: changed the

greater-than-or-equal-to sign to a regular greater-than sign

Anonymous  Jan 1998
Printed Page 70
last column's header in first table: changed "S.B 4" to "T.B

4" (the 4's a subscript

Anonymous  Sep 1997
Printed Page 70
table 2: made column S.A3 white and column S.A4 shaded

Anonymous  Jan 1998
Printed Page 70
1st and 2nd tables: the "h" in the lower

right-hand cells changed to "j"

Anonymous  Jul 1998
Printed Page 70
first table, header "S.A1": the subscript "1" is now bold, not italic

Anonymous  Nov 1998
Printed Page 73
3rd table: the "h" in the lower right-hand

cell changed to "j"

Anonymous  Jul 1998
Printed Page 76
column B3: made the upper-case "I"s into "i"s

Anonymous  Jan 1998
Printed Page 81
changed

(sel S.A2 = T.A2, S.A4 = T.A4(SxT))

to:

(sel S.A1 = T.A1(SxT))

Anonymous  Jan 1998
Printed Page 89
para. beginning "(In SQL-92...": changed

"this clauses has" to "these clauses have"

Anonymous  Jul 1998
Printed Page 90

code sample 3 now reads:

CREATE TABLE BOOKS2
(ISBN TEXT(13) CONSTRAINT PrimaryKeyName PRIMARY KEY,
TITLE TEXT(100),
PRICE MONEY,
PubID TEXT(10), CONSTRAINT Test FOREIGN KEY (PubID) REFERENCES Publishers
(PubID));

Anonymous  Nov 1998
Printed Page 97
line 1 of first code example: changed "DISTINCT" to "DISTINCTROW"

Anonymous  Sep 1997
Printed Page 101
Changed the sentence after Table 6-7 from

"This is, in fact, the semi-join"
to

"This is, in fact, a projection of the semi-join"

Anonymous  Mar 1999
Printed Page 104
next-to-last line on page: removed ";" and added it to the end

of the last line; also, changed the first line of that code example to
read:

SELECT PUBLISHERS.PubName, MIN(Price) AS [Minimum Price]

Anonymous  Jan 1998
Printed Page 104
para, under "GROUP BY GroupByCriteris",

last sentence: changed "the order of column names
in determines" to "the order of column names determines"

Anonymous  Jul 1998
Printed Page 104
Under the heading for the "Having" option

"The HAVING option in used in conjunction ..."

now reads

"The HAVING option is used in conjunction ..."

Anonymous  Nov 1998
Printed Page 107
line 2: changed "form" to "from"

Anonymous  Jan 1998
Printed Page 108
last line: changed "indicies" to "indices"

Anonymous  Jul 1998
Printed Page 110
middle para.: deleted extra "than one"

Anonymous  Jan 1998
Printed Page 116
next-to-last line: changed "Jet DMBS" to "Jet DBMS"

Anonymous  Sep 1997
Printed Page 122
Example 7-1, removed the line: dbLibrary.Name = "LIBRARY"

Anonymous  Mar 1999
Printed Page 123
Changed the line

Set dbLibrary = ws.OpenDatabase("d:daolibrary.mdb")
to

Set dbLibrary = DBEngine.OpenDatabase("d:daolibrary.mdb")

Anonymous  Mar 1999
Printed Page 125
para. 2 line 4: changed "below" to "above"

Anonymous  Jan 1998
Printed Page 128
last line: changed "Holliday" to "Holiday"

Anonymous  Jan 1998
Printed Page 138
Example 8-1: changed the first line from

intGrade = Val(InputBox("Enter student's average _ test score: "))

to

intGrade = Val(InputBox("Enter student's average test score: "))

Anonymous  Jul 1998
Printed Page 142
added a line to the first code example

intvar = 123

It goes after the current second line.

Anonymous  Sep 1997
Printed Page 147
Figure 9-5: Two boxes in the diagram Containers and Documents should be

connected. And Containers should also be connected to the horizontal
line immediately above it (that originates from Databases).

Anonymous 
Printed Page 147
1st line of text: changed "is the just" to "is just the"

Anonymous  Jan 1998
Printed Page 147
figure 9-5 is new.

Anonymous  Jan 1998
Printed Page 149
figure 9-7 is also new.

Anonymous  Jan 1998
Printed Page 157
Changed the line

"of the previous example, we could have written"
to

"we can write"

Anonymous  Mar 1999
Printed Page 158
2nd para., 1st line: changed

Running the code in Exaple 9-6 produces the message box
shown in Fiure 9-8,
to
Running the code in Exaple 9-6 produces two message boxes;
the second is shown in Fiure 9-8,

Anonymous  Jul 1998
Printed Page 161
4th line from bottom: changed "use to this" to "use this"

Anonymous  Jan 1998
Printed Page 171
example 9-10: in the example title, changed "Container" to

"Containers"

Anonymous  Sep 1997
Printed Page 176
last line: fixed the weird font problem

Anonymous  Jan 1998
Printed Page 177
in step 5 in the box, changed "dbOne.Table..." to "dbTwo.Table..."

Anonymous  Sep 1997
Printed Page 191
line 2 on page: added a comma after "QueryDefName"

Anonymous  Sep 1997
Printed Page 193
Changed the line

strSQL = "UPDATE BOOKS SET Price = Price*1.1 WHERE Price > 20"

to

strSQL = "UPDATE BOOKS SET Price = Price*1.1"

Anonymous  Mar 1999
Printed Page 193
Changed the line

If qdf.RecordsAffected > 15 Then

to

If qdf.RecordsAffected <= 15 Then

Anonymous  Mar 1999
Printed Page 193
The following two lines of Example 10-7 were modified so that

they appear as follows:

MsgBox qdf.RecordsAffected & _
" records affected by this query. Transaction cancelled."

Anonymous  Apr 1999
Printed Page 202
Replaced the line

Msgbox rsTable!Title

with the two lines

If Left$(tsTable!Title,2) = "On" then
Msgbox rsTable!Title

Anonymous  Mar 1999
Printed Page 205
At the second bullet point, inserted the word "valid" between

"there is no" AND "current record". So it now reads "there
is no valid current record"

Anonymous  Apr 1999
Printed Page 230
In line 2, inserted the words "are sufficient to" after the

words "rows of a table that"

Anonymous  Apr 1999
Printed Page 231
Replaced double arrow symbol with a large X, as on page 62 under the

definition of cartesian product.

Anonymous  Mar 1999
Printed Page 232
In Table B-4

1. Changed the last cell in the last row to "red oak"
2. Added another row with first cell "Fred's Woods" and second cell
"poplar."
3. Added another row with first cell "Fred's Woods" and second cell
"mahogany."

Anonymous  Mar 1999
Printed Page 237
In paragraph numbered 4, in the second to last line, changed "right" to

"left."

Anonymous  Mar 1999
Printed Page 238
In the table at bottom: changed Meville to Melville.

Anonymous  Mar 1999
Printed Page 245
Two headings were added at the beginning of the index: "Symbols," and

"Numbers."

Anonymous  Mar 1999
Printed Page 246
In column 1, line 13

"for specific objects, ??-229, 210-??"

was changed to:

"for specific objects, 210-229"

Anonymous  Mar 1999
Printed Page 253
added the following to the end of the next-to-last para.

Whenever possible, our books use RepKover (tm), a durable and flexible
lay-flat binding. If the page count exceeds RepKover's limit, perfect
binding is used.

Anonymous  Sep 1997
Printed Page 253
Colphon, 2nd para., line 2: changed "Quark Xpress 3.5" to

"QuarkXpress 3.3"

Anonymous  Jul 1998