ADDWKCODE

Returns workshop codes in which individual is registered for specific course.

Reporting Area(s)

Workshop, Registrations

Required Parameters:

  1. Course # (i.e. cocrse, rgcrse, pycrse) + Name ID (i.e. nmid, rgid, pyid)

Optional Parameters:

  1. Delimiter to place between returned values (i.e. " -- ", ", ")
  2. Condition to return values based on Workshop Individual Records table (i.e. " wicode = 'A' ")
  3. Logical .t. trim workshop code (eliminate trailing blanks)

Example(s):

ADDWKCODE(rgcrse+rgid," -- ") returns all workshops individual is registered for separated by '--'

ADDWKCODE(rgcrse+rgid,","wicode = 'A' ",.t.) returns all workshops with 'A' as the first character of workshop # i.e. "A001","AM002"

Notes:

Useful when you just want to show the Workshop #s, such as when printing Nametags. Course # and Name ID are passed as one parameter and must be combined with plus sign (+).

 

Related Topics Link IconRelated Topics