APRESS.COM : Beginning VB 2008 Databases: From Novice to Professional : 9781590599471

Beginning VB 2008 Databases: From Novice to Professional book cover

By Vidya Vrat Agarwal James Huddleston
ISBN13: 978-1-59059-947-1
ISBN10: 1-59059-947-0
409 pp.
Published Apr 2008
Print Book Price: $44.99
eBook Price: $31.49

My eBook

Errata Submission

If you think that you've found an error in Beginning VB 2008 Databases: From Novice to Professional, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

Submit Errata

Errata

Issue	Author's Response
Chapter 9 examples have source code in C#. This is a Virtual Basic edition!!!	Chapter-9, Listing-2 "How It Works" section reads Imports System.Data.OleDb; Need to remove ;(Semicolon) at the end of statement, to make it VB specific.
The very first sample program in Chapter 2 on page 20 in the section "Creating A Simple Console Application Project Using Visual Studio 2008" is called "FirstApp." This example did not work for me until I realized I had to change my startup object from "Module1" to "FirstApp.Program". I figured this out but no thanks to this book, thanks to my prior experience. Most people who would be doing this example would not need this example if they could figure this out for themselves. I have a bad feeling about the rest of this book.	Add instruction to modify Startup Object from Project Properties to the Application name "FirstApp" and then exexute or run the application.
Ch2 p.20 "How it Works" in sentence should be starting with the Imports directives not using (directive in c#). thanks	This need a fix. on p-20 below the How it works heading, we need to replace the keyword using with Imports. Thanks
When trying to execute the code on pages 19 and 345, Visual Basic gives the following error: 'Sub Main' was not found in 'ConsoleApplication1.Module1'. There seems to be a problem with using "Namespace" and/or "Class" within a module application. The other examples do not use either of those keywords, and they work. I do not know enough about module applications to troubleshoot. Also, I found some random C# snippets throughout the book, code commented out that should not have been, and most of the console applications do not include a Console.ReadLine() call to allow one to view the results.	Hi, I performed the steps again, as mentioned in the book. I could not re-produce the issue you mentioned. You need to be more explicit or send me the project/solution at vidya_mct@yahoo.com. Yes, we may have some C# language's bits and pieces. We will remove them , thanks. Also, I will do a complete walkthrough for all the console applications to add Console.ReadLine(). Thanks again.
p38, 3rd line from bottom states "* Name of the CTE followed by the WITH keyword" but the example shows the WITH keyword _PRECEEDING_ the name of the CTE.	p38, 3rd line from bottom should be revised to state WITH keyword followed by the Name of the CTE. Thanks
Chapter 11, p. 190, Table 11-1: The "executescalar" method is missing.	Thanks, we will add it into the next available printing edition: On P-190 under Table-11-1 ExecuteScalar needs to be added as follows: Table header:- If the command is going to return -------- You should be --------------------------------------------------------------------------------------- Description - Single Value (Aggregate Value) ---------- ExecuteScalar
Chapter 1, pg 9, under Installing the AdventureWorks Creation Script.. Step 1. Navigate to the following URL... does no longer exists. I tried to search the site for the AdventureWorksDB, but no luck, I need that file to perform the exercises in the book, please help.	Follow the URL http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004 and choose AdventureWorksDB.msi
Ch2 p.20 "How it Works" reference should be to "module.vb" not "program.cs" and I do not think the code snippet is correct in the lines above. Overall, rather sloppy cut and paste from C# volume of the same name and content. (I guess only fools like myself have purchased both volumes and expect more effort for our dollar).	This needs to be resolved as Module.vb.
Chapter 2, Page 37, Testing Simple Addition script, should be; 'If (result <> 3) Then'	provided chapter and page reference is not showing the code as mentioned in the submitted errata

Issue

Author's Response

Chapter 9 examples have source code in C#. This is a Virtual Basic edition!!!

Chapter-9, Listing-2 "How It Works" section reads Imports System.Data.OleDb;

Need to remove ;(Semicolon) at the end of statement, to make it VB specific.

The very first sample program in Chapter 2 on page 20 in the section "Creating A Simple Console Application Project Using Visual Studio 2008" is called "FirstApp." This example did not work for me until I realized I had to change my startup object from "Module1" to "FirstApp.Program". I figured this out but no thanks to this book, thanks to my prior experience. Most people who would be doing this example would not need this example if they could figure this out for themselves. I have a bad feeling about the rest of this book.

Add instruction to modify Startup Object from Project Properties to the Application name "FirstApp" and then exexute or run the application.

Ch2 p.20 "How it Works"
in sentence should be starting with the Imports directives not using (directive in c#).
thanks

This need a fix.

on p-20 below the How it works heading, we need to replace the keyword using with Imports.

Thanks

When trying to execute the code on pages 19 and 345, Visual Basic gives the following error:
'Sub Main' was not found in 'ConsoleApplication1.Module1'.
There seems to be a problem with using "Namespace" and/or "Class" within a module application. The other examples do not use either of those keywords, and they work. I do not know enough about module applications to troubleshoot.

Also, I found some random C# snippets throughout the book, code commented out that should not have been, and most of the console applications do not include a Console.ReadLine() call to allow one to view the results.

Hi,

I performed the steps again, as mentioned in the book.

I could not re-produce the issue you mentioned. You need to be more explicit or send me the project/solution at vidya_mct@yahoo.com.

Yes, we may have some C# language's bits and pieces. We will remove them , thanks.

Also, I will do a complete walkthrough for all the console applications to add Console.ReadLine(). Thanks again.

p38, 3rd line from bottom states
"* Name of the CTE followed by the WITH keyword"

but the example shows the WITH keyword _PRECEEDING_ the name of the CTE.

p38, 3rd line from bottom should be revised to state
WITH keyword followed by the Name of the CTE.

Thanks

Chapter 11, p. 190, Table 11-1: The "executescalar" method is missing.

Thanks, we will add it into the next available printing edition:

On P-190 under Table-11-1 ExecuteScalar needs to be added as follows:

Table header:- If the command is going to return -------- You should be
---------------------------------------------------------------------------------------
Description - Single Value (Aggregate Value) ---------- ExecuteScalar

Chapter 1, pg 9, under Installing the AdventureWorks Creation Script.. Step 1. Navigate to the following URL... does no longer exists.

I tried to search the site for the AdventureWorksDB, but no luck, I need that file to perform the exercises in the book, please help.

Follow the URL
http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

and choose AdventureWorksDB.msi

Ch2 p.20 "How it Works"
reference should be to "module.vb" not "program.cs" and I do not think the code snippet is correct in the lines above. Overall, rather sloppy cut and paste from C# volume of the same name and content. (I guess only fools like myself have purchased both volumes and expect more effort for our dollar).

This needs to be resolved as Module.vb.

Chapter 2, Page 37, Testing Simple Addition script, should be;

'If (result <> 3) Then'

provided chapter and page reference is not showing the code as mentioned in the submitted errata