Errata – Visual Basic and Databases – 2015 Edition
Page 5-38 Example 5-3
Line reads: Dim Response As Windows.Forms.DialogResult
For some reason, that is rejected in the 2017 IDE. I checked the Object Browser and the References listed in the Properties and it looks like it should work but in the Community version of Visual Studio 2017 it did not work. It works as, Dim Response As System Windows.Forms.DialogResult or as Dim Response As DialogResult or as Dim Response = DialogResult but not as written.
Page 5-42, lines 2 and 3 say: “In View state, the user can navigate from record to record, add and/or edit records, delete a record, or exit the application. In View state, data cannot be changed.”
That is a contradiction. If a record can be added, deleted, or edited, the data is being changed.
On Page 5-48, paragraph 3, line 1:
Currently: “We need someone way of distinguishing what keys are pressed.”
Should be: “We need some way of distinguishing what keys are pressed.”
On Page 5-51, 4th è, 2nd sentence:
Currently: “Some fields only need to filled in if other fields are filled in.”
Should be: “Some fields only need to be filled in if other fields are filled in.”
On Page 5-51, 3rd paragraph, 3rd sentence:
Currently: “You, as the programmer, need to examine each input field and answer the questions posed above: is the field required, must it be within a range, is it length restricted, is it conditional?”
Should be: “You, as the programmer, need to examine each input field and answer the questions posed above: is the field required, must it be within a range, is its length restricted, is it conditional?”
On Page 5-96, 2nd paragraph:
The menus have changed in the Community 2017 edition. To display the Choose Toolbox Items the user can just right-click on any item in the Toolbox and select Choose Items from the menu.
On Page 6-11, next to last line:
There is no SetState(“View) at this point in the program. The listing for SetState is on page 6-18.
On Page 6-31, code:
Visual Studio 2017 puts a red squiggly underline under “Windows.Forms” in the line “Windows.Forms.DialogResult.Yes Then”. Change to, “DialogResult.Yes Then”.
On Page 6-33, last paragraph:
The sentence that begins, “If now such row is found,” should be “If no such row is found,”.
On Page 6-78:
The text for Label1 and Label2 are set to Title. The diagram on page 6-80 shows that Label2 is supposed to Year Published. Not a big deal but could be confusing.
On Page 6-93:
Label1 is actually inserted as Label8.
Text1 is inserted as TextBox1.
On Page 6-106, second paragraph, first sentence:
“Click Edit and you can scroll through the records and notice how the combo box properly displays the publisher name.”
If Edit is selected you cannot scroll through the records.
“publisher name” should be “publisher’s name”
On Page 6-106, second paragraph, second sentence:
“Click the drop-down arrow in the combo box and notice that the displayed name is highlighted (selected) among the order choices.”
The selection is not highlighted in VS 2017.
“order” be “other”?
On Page 7-5, 3rd paragraph, 2nd sentence:
“The e.HasMorePages property (Boolean) is used specify which possibility exists.”
“The e.HasMorePages property (Boolean) is used to specify which possibility exists.”
On Page 10-21
#1 says, “Add a three buttons…”
“Add three buttons…”
On Page 10-60
In step 1, 4th sentence:
“Add eights fields (columns) to the…”
Not 7 fields.
On Page 10-69, line 5:
Currently Reads, ‘connect to the sales database”
Should be inventory, SQLInventoryDB.mdf, or just leave out sales.
On Page 10-74, 1st sentence:
“As a first step, we need to ability to move…”
“As a first step, we need the ability to move…”
On Page 10-128, in code at the bottom of the blue area:
Call grdWeather_CellClick(Nothing, Nothing)
grdWeather_CellClick is not defined until page 10-137 so it creates an error at this point.
On Page 10-154, line 1:
Instructions say to add four labels but there are five listed in the property settings right below. Two are titled “Label1:” so the count comes out wrong on the page. It should be “Label1:” through “Label5:”.
You may experience a corrupted database while running SQL Tester:
You may see it when you scroll to the right and hit the SSMA_TimeStamp column and you get get…
This is the preview of the data.
If you experience a corrupted
** Special Thanks to David Taylor, the VB Professor, for helping update this Textbook Errata which is helping us prepare for a Visual 2019 Update of the Tutorial after Visual Studio launches in April 2019 **