Skip to content

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

  1. Name ID (i.e. nmid, rgid, pyid)

Optional Parameters

  1. Condition for course dates ("Cobegdate > Date()")
  2. Condition for course ("codept='Computer'", "coactive=.t.")
  3. Logical .t. show location, .f. don't show. Must be enclosed in quotations, i.e. ".t."
  4. Delimiter: character to place between courses ("--", "/", CHR(13) Carriage Return (default) )
  5. 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

  1. 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 '--'

HASCLASS
LASTCLAS