Ok, Chapter 5 seems to be real popular. So, having worked through it, I am using this space to make some comments on the solutions and possible errata I found. For errata, please be sure to cross-check me on the book's errata page.

1. [u]Figure 5-7</u> This little Try It Yourself seemed to be most popular. For me, everything worked, until I tried to test the query. It displayed the column titles - but no info.

This is because the Figure itself and the accompanying text is is error: Step 8 details how to fill out the "Add WHERE Clause" dialog. However, the text neglects to mention (and the Figure does not display) that on the right under "Parameter properties" that the "Default Value" field must be filled in with one of the valid PersonID values. Both text and Figure stop at the "QueryString Field" by directing the user to type into it: PersonID - then it says to click Add and Ok. Without the "Default Value" field filled, the query won't know which specific PersonID you are seeking.

So, if you follow the directions in Step 8, tab down to the next field "Default Value" and enter 1 for that PersonID. When you test the query and run the app, it should being up all of George Washington's books - since he corresponds to PersonID=1.

I will share more if and when I come across these items.

ThomasT

Update:

On the "Default Value" issue: In the very next Try It Yourself, the accompanying figure (Figure 5-10) also does not show entering anything into "Default Value" of the custom query steps.

However, it does mention in the text that you do not have to enter anything there, but instead you can wait until you test the query. A small dialog box will pop up prompting you for a default value. The dialog will imply that the value for AuthorID is missing. The line reads:

AuthorID | Int32 | <blank>

In the <blank> enter a valid PersonID to filter for. If you did fill in the "Default Value" field before testing, you can change it here as well.

ThomasT