Wrox Programmer Forums
|
BOOK: Beginning VB.NET Databases
This is the forum to discuss the Wrox book Beginning VB.NET Databases by Thearon Willis; ISBN: 9780764568008
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning VB.NET Databases section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 22nd, 2010, 10:44 PM
Registered User
 
Join Date: Apr 2010
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default LoadTimeSheet

Hi Chuck,

I encounter the same problem as yours. How is it solved? Pls tell me

Many thnaks to you

Pisith Oum
 
Old July 26th, 2012, 11:48 AM
Registered User
 
Join Date: Jul 2012
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Fix for CH12 LoadTimeSheet()

So, after troubleshooting the this problem for a while I found that the problem is that the GroupProjects information in the application is not persistent, i.e. never gets loaded into the GroupProjects table. Unfortunately, this is the same table which the InsertTimeSheet Stored Procedure uses to populate the TimeSheetItems table. While, not the original intent of the logical flow of the program, the following fix will allow one to test the functionallity of the program. It effetively grabs project information from the Project table instead of the GroupProjects table allowing you to test the functionality.

Change the following line in the usp_InsertTimeSheet Stored Procedure

SQL Server:
Change

Declare Project_Cursor CURSOR FOR SELECT ProjectID
FROM GroupProjects WHERE GroupID = @GroupID


to

Declare Project_Cursor CURSOR FOR SELECT ProjectID FROM Projects

Oracle
Change

CURSOR Project_Cusor IS SELECT ProjectID FROM GroupProjects WHERE GroupID = varGroupID;

to

CUSROR Project_Cursor IS SELECT ProjectID FROM Projects;

Again, this does not meet the intent of the flow of the program, fixing that would require quite a bit more code, but it will at least allow anyone stuck at this point to move forware with the example code.





Similar Threads
Thread Thread Starter Forum Replies Last Post
CH 12 login nightmare gegala BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 2 December 31st, 2007 09:34 AM
ch 12 php logins ejurasin BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 1 March 13th, 2006 02:24 PM
Ch. 12 Connect.asp mcauliff BOOK: Beginning ASP 3.0 2 August 5th, 2005 02:47 PM
Ch. 4 & Ch. 12 athena BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 July 23rd, 2004 10:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.