ADDREG ​
Returns the value of a field from Register table.
Reporting Area(s) ​
Registrations
This function can also be used on ACEweb templates where the name ID AND course code are available. Contact your ACEware technician for more information.
Required Parameters ​
- Course # (i.e. cocrse, rgcrse, pycrse) + Name ID (i.e. nmid, rgid, pyid)
- Field from the Registration table to return (i.e. "rgaddate", "rgfee", "rgstatus")
Optional Parameters ​
None
Example(s) ​
ADDREG(cocrse+rgid,"rgstatus") returns value of registrant Status field
ACEweb Examples ​
The VFP version uses the rgcrse+rgid value. Rgcrse must be padded to 12 characters.
##addreg(padr(tCard.cocrse,12," ")+tPerson.nmid,"rgstatus")##
The SQL version uses the rgoid value.
##addreg(rgoid,"rgstatus")##
Notes ​
Course # and Name ID are passed as one parameter and must be combined with plus sign (+), e.g. cocrse+nmid.