SHOWWORK
Returns workshops taken by registrant, with or without instructor name and options to select specific fields.
Reporting Area(s)
Registrations
Required Parameters
- Course # (i.e. cocrse, rgcrse, pycrse)
- Name ID (i.e. nmid, rgid, wiid)
Optional Parameters
- Logical .t. print workshop instructor, .f. don't print
- Delimiter to place between fields (i.e.: " ", ",", Chr(9))
- Field from Workshop Master Record to return (i.e.: "wmtitle", wmleader", "wmnote"). Default is Title Note Leader. If you want to return a field from the Workshop Individual Record, you must preface the field name with WKSHPIND. (i.e. WKSHPIND.wigrade)
- Delimiter to place between workshop records (i.e. "-", " ", CHR(13) carriage return (default))
- Logical .t. don't show message indicating orphan workshop code (i.e. 'NO MASTER WK RECORD:'), .f. show message (default)
- Condition to show workshop records (i.e. "wmcode='A' ")
Example(s)
SHOWWORK(rgcrse, rgid) returns Workshop Title, Workshop Note, Leader
SHOWWORK(rgcrse, rgid, .F., "", "wmtitle") returns Workshop Title only
SHOWWORK(pycrse,pyid,.f.,"","dtoc(wmdate)+chr(9)+wmtime+chr(9)+trim(wmtitle)+chr(9)+'$'+str(wmfeeamt,6,2)") returns Workshop date, time, title and fee amount separated by tabs
SHOWWORK(rgcrse, rgid, .F., "","WKSHPIND.wigrade") returns the Workshop Grade
Related Functions
ADDWKCODE
ADDWORK
CTWORK
CURSWORK
CUSTWKCD
LISTWORK
QUIKWORK
SELEWORK
SELEWORK2
SHOWWKMS
STAMPWORK
SUMWORK