version 6.0.5
AP Get field infos (table; field; relTable; relFld; props; choiceList) Integer
Parameter | Type | Description | |
table | Integer | Table number | |
field | Integer | Field number | |
relTable | Integer | Related table | |
relFld | Integer | Related field | |
props | Longint | Field properties | |
choiceList | String | Choice 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: |
15 | Indexed | Text, Picture, Subtable or Blob |
14 | Indexed unique | Text, Picture or Subtable or Blob or if bit 15 is |
set to 0 | ||
13 | Mandatory | Subtable |
12 | Choice list | Picture, Subtable or Blob |
11 | Modifiable | Subtable |
10 | Enterable | Subtable |
8 | Invisible | |
6 | N to 1 relation | Text, Picture, Subtable or Blob |
5 | 1 to N relation | Text, Picture, Subtable or Blob |
2 and 1 | Automatic 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 | ||
0 | Automatic 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.