loadASITable

Version

1.6

Parameters

Parameter Type Description
tname string Name of ASI table to load.
capId (optional) CapIDModel Record ID from which to load the table.

Returns

Returns an array of associate arrays that contain objects representing the contents of the ASI table for the selected record.

Notes

The underlying object is an “asiTableValObj” that contains three properties:

  • fieldValue = value of the table

  • columnName = name of the column for this value

  • readOnly = Y for a read only field, N if not.

Example

myTable = loadASITable(“EXAMPLE TABLE”) 
firstRow = myTable[0]; 
columnA = firstRow[“Column A”] 
columnB = firstRow[“Column B”] 
comment(“value of column a is : “ + columnA.fieldValue) 
comment(“column a read only property is : “ + columnA.readOnly) 

The fieldValue property of the asiTableValObj object is the default property, so the following also works:

comment(“value of column a is : “ + columnA);