Filemaker TH325Z/A Fiche technique télécharger pdf (Page 48)

48 FileMaker Functions Reference

Example

On the Data Entry layout in the Customers database file,

FieldStyle(“Customers”;“Data Entry”;“Current Customer”) returns

RadioButton Yes/No List when the Current Customer field is formatted as a radio button

and is associated with the value list named Yes/No List.

FieldType

Format

FieldType(fileName;fieldName)

Parameters

fileName - the name of an open database file (local or remote).

fieldName - the name of a field in the specified database file.

Important See “Design functions” on page 41 for information about literal text parameters.

Data type returned

text

Description

Returns information about fieldName. Field names must be in the form

tablename::fieldname to specify a field that exists in a table different from the current

table. The result has four values separated by spaces:

• The first value is either Standard, StoredCalc, Summary, UnstoredCalc, or Global.

• The second value is the field type: text, number, date, time, timestamp, or container.

• The third value is Indexed or Unindexed.

• The fourth value is the maximum number of repetitions defined for the field (if the field

isn’t defined as a repeating field, this value is 1).

Examples

FieldType(“Customers”;“Phone Number”) returns Standard Text Unindexed 3,

when, in the Customers database file, the Phone Number field is defined as a text field

that repeats a maximum of 3 times and the storage options are left unchanged. (Most

fields are indexed

when a find is performed in that field.)

FieldType(“Customers”;“Current Balance”) returns StoredCalc Number

Indexed 1, when, in the Customers database file, the Current Balance field is defined as

a stored, numeric calculation field that is indexed.

FieldType(“Customers”;“Today’s Date”) returns Global Date Unindexed 1,

when, in the Customers database file, the Today’s Date field is defined as a global field of

type date. Global fields are never indexed.

1 2 ... 43 44 45 46 47 48 49 50 51 52 53 ... 237 238

Pas de commentaire

Filemaker TH325Z/A Fiche technique Page 48