SHOWCLAS ​
Returns quick summary of courses taken for a single individual with the ability to specify courses by date or by course number.
Reporting Area(s) ​
Names, Registrations
Required Parameters ​
- Name ID (i.e. nmid, rgid, pyid)
Optional Parameters ​
- Condition for course dates ("Cobegdate > Date()")
- Condition for course ("codept='Computer'", "coactive=.t.")
- Logical .t. show location, .f. don't show. Must be enclosed in quotations, i.e. ".t."
- Delimiter: character to place between courses ("--", "/", CHR(13)-Default..)
- Numeric return value:
0= Course Number, Title, Dates, Location
1= Course Number only
2= Course Title only
3= Course Number & Course Begin Date
4= Course title & course begin date
5= Course Number and Title
6= Course Number, Title, Date, Ceus, Hours
7= Course Number, Title, Date, Ceus
8= Sum of Ceus
9= Sum of Hours
10= Course Number, Title, Date, Ceus, Hours, Grade
- Field to return from Course table (i.e. "codept", "cocoord")
Example(s) ​
SHOWCLAS(rgid) returns course number, title, dates, and location off all courses individual has taken
SHOWCLAS(rgid,"","",".f."," ",5) returns course number and title of all courses individual has taken separated by 5 spaces
SHOWCLAS(rgid,"cobegdate < date()""codept='accounting'",".f.","--",1) returns course number off all courses individual has taken in the Accounting department prior to current date separated by '--'