Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 04 Feb 2009 at 9:04am
Note that since i do not know how your DB is set up you may want to start by back tracking from your SP and go straight to the tables. The relational table design may lend itself to be able to do what you want without much additional work.
Joined: 03 Feb 2009
Location: United States
Online Status: Offline
Posts: 13
Posted: 04 Feb 2009 at 12:48pm
Here are the fields the SP is returning to the form
TextTerm Department CourseID Section CourseType CourseName Credits Grade GradePoint CreditFactor TermEarned CumulativeEarned TermGPAHours CumulativeGPAHours OverAllGradePoint OverAllCreditFactor TranscriptAttHours TranscriptErnHours AdjCumulativeEarnedHours AdjCumulativeGPAHours AdjCumulativeGradePoint GradeLevel firstname MiddleInitial lastname Address1 Address2 City State ZipCode
The second semester could have different courses and different number of courses:
9th Grade First Semester Second Semester Algebra 1 Algebra 1 Algebra 2 Algebra 2 Am History Am Gover Bible Am History Biology Bible Eng 1 Bilogy Health English 1 HSB Health PE HSB Spanish 1 PS Typing Spanish 1 WG Typing LOC LOC
10th Grade Bible Bible Chemisty Chemistry Computer Computer Advanced Math Advanced Math English Comp 1 English Comp II Western Civ PS
11th Grade Bible Bible Computer Computer English III English III Physucal Education Spanish Spanish 2 Trig PreCalc Trig Physics Physics
---------------------------
George W. Gardei
IT CAMS Manager
God's Bible School and College
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 04 Feb 2009 at 2:33pm
Hi George,
Not sure if you are requesting assistance on this and if so exactly what you need. I may not be available for a few days so hopefully Rahul can give you a hand if needed.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
