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.