4D Doc Center : AP Get field infos

4D Pack v13.2

AP Get field infos


AP Get field infos ( numTable ; numField ; relTable ; relFld ; props ; choiceList ) -> Function result

Parameter	Type	Description
numTable	Integer	Table number
numField	Integer	Field number
relTable	Integer	Related table
relFld	Integer	Related field
props	Longint	Field properties
choiceList	String	Choice list
Function result	Integer	Error code

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 with automatic assignment	Text, Picture, Subtable, Blob, or if bit 5 not set