Command AP Get field infos

4D Pack

AP Get field infos

version 6.0.5


AP Get field infos (table; field; relTable; relFld; props; choiceList) Integer

ParameterTypeDescription
tableIntegerTable number
fieldIntegerField number
relTableIntegerRelated table
relFldIntegerRelated field
propsLongintField properties
choiceListStringChoice list

Function result Integer Error code

Description

AP Get field infos returns specific information about a field.

Given the table number and field number, the command returns the linked table and the linked field number, respectively.

If there is no relation with the given field, relTable and relFld are set to 0.

The 16 bits of props are meaningful. Each bit can be read via bits operators of 4D language.

Bit number:Is set to 1 if:Ignored if field type is:
15IndexedText, Picture, Subtable or Blob
14Indexed uniqueText, Picture or Subtable or Blob or if bit 15 is
set to 0
13MandatorySubtable
12Choice listPicture, Subtable or Blob
11ModifiableSubtable
10EnterableSubtable
8Invisible
6N to 1 relationText, Picture, Subtable or Blob
51 to N relationText, Picture, Subtable or Blob
2 and 1Automatic 1 to N relation whose
deletion control is:
00 No deletion control
01 No assignment of related records
10 Deletion of related records
11 Deletion of related records not allowed
0Automatic N to 1 relation Text, Picture, Subtable, Blob, or if bit 5 not set
with automatic assignment

Note: Bits 3, 4, 7 and 9 are reserved for future use.

If bit 12 is set, the variable choiceList contains the name of the list.