4D Doc Center : GET FIELD PROPERTIES

4D v13.4

GET FIELD PROPERTIES


GET FIELD PROPERTIES ( fieldPtr \| tableNum {; fieldNum}; fieldType {; fieldLength {; indexed {; unique {; invisible}}}} )

Parameter	Type	Description
fieldPtr \| tableNum	Pointer, Longint	Table number or Field pointer
fieldNum	Longint	Field number if Table number is passed
fieldType	Longint	Type of field
fieldLength	Longint	Length of field, if Alphanumeric
indexed	Boolean	True = Indexed, False = Non indexed
unique	Boolean	True = Unique, False = Non unique
invisible	Boolean	True = Invisible, False = Visible

The GET FIELD PROPERTIES command returns information about the field specified by fieldPtr or by tableNum and fieldNum.

You either pass:

After the call:

fieldType returns the type of the field. The fieldType variable parameter can take a value provided by the following predefined constants:

The fieldLen parameter returns the length of the field, if the field is Alphanumeric (i.e., fieldType=Is Alpha Field). The value of fieldLen is meaningless for the other field types.
The indexed parameter returns True is the field is indexed, and False if not. The value of indexed is meaningful only for Alphanumeric, Integer, Long Integer, Real, Date, Time, and Boolean fields.
The unique parameter returns True if the field is set to “Unique”, else False.
The invisible parameter returns True if the field is set to “Invisible”, else False. The Invisible attribute can be used to hide a given field in 4D standard editor (label, charts...).

This example sets the variables vType, vLength, vIndex, vUnique and vInvisible to the properties for the third field of the first table:

GET FIELD PROPERTIES(1;3;vType;vLength;vIndex;vUnique;vInvisible)

This example sets the variables vType, vLength, vIndex, vUnique and vInvisible to the properties for the field named [Table3]Field2:

GET FIELD PROPERTIES(->[Table3]Field2;vType;vLength;vIndex;vUnique;vInvisible)