Hi David,
>>The other thing that jumped out at me is there is no integer primary key. Primary keys should be meaningless numbers not fields tied to courses or whatever..
>
>There is certainly no hard fast rule that a temporary cursor have a primary key at all. This very well could be a final output cursor that's about to go to a spreadsheet and the consumers of the spreadsheet have no need to see PKs (or FKs for that matter).
PMFJI - Can a temporary cursor have a PK? I thought PK's were restricted to tables in a DBC.
Regards,
Mike
"We try to solve the problem by rushing through the design process so that enough time is left at the end to uncover the errors that were made because we rushed through the design process."
- Glenford Myers
If you're going through hell, keep going. - Walt Disney