Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB.NET 1.0 > BOOK: Beginning VB.NET Databases
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #11 (permalink)  
Old April 22nd, 2010, 11: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
Reply With Quote
  #12 (permalink)  
Old July 26th, 2012, 12:48 PM
Registered User
Points: 3, Level: 1
Points: 3, Level: 1 Points: 3, Level: 1 Points: 3, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 03:47 PM
Ch. 4 & Ch. 12 athena BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 0 July 23rd, 2004 11:54 AM



All times are GMT -4. The time now is 08:24 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.