ADDOMNI

Returns any field from any table in the system as long they have a key value for that table.

Reporting Area(s):

General

Required Parameters:

  1. Table you want to return a field from in quotes (i.e. "NAMES", "COURSE", "REGISTER")
  2. Key from above table in quotes (i.e. "nmid" or "nmid+rgcrse")
  3. Key from report cursor, NO quotes (i.e. nmid or nmid+cocrse)
  4. Field from specified table to return (i.e. "nmsalut", "cosubcode", "rggrade")

Optional Parameters:

  1. Condition to return field (i.e. "nmorg='C' ", "cocoord='Havlicek'", "rgtrack='03BROC' ")

Example(s):

ADDOMNI("NAMES","nmid",rgid,"nmsalut") returns value of Salutation field

ADDOMNI("NAMES","nmid",rgid,"nmsalut","nmorg='MED'") returns value of Salutation field if NMORG contains "MED"

ADDOMNI("NAMES","nmid+rgcrse",nmid+rgcrse,"rggrade") returns grade for specific individual in specific course

 

Related Topics Link IconRelated Topics