ADDREG

Returns the specified field from the Registration 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

1. Course # (i.e. cocrse, rgcrse, pycrse) and Name ID (i.e. nmid, rgid, pyid) entered with a plus sign between the 2 (i.e. cocrse+rgid)
2. 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.

Related Functions

ADDRGUNL
ADDRUDFS