Filemaker Pro 8.5 Advanced Maintenance TG762Z/A ユーザーズマニュアル
製品コード
TG762Z/A
48 FileMaker Functions Reference
Example
On the Data Entry layout in the Customers database file,
FieldStyle(“Customers”;“Data Entry”;“Current Customer”) returns
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
(local or remote).
fieldName - the name of a
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
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.
•
: text, number, date, time, timestamp, or
•
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
isn’t defined as a
, 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
that repeats a maximum of 3 times and the storage options are left unchanged. (Most
fields are
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
of
type date. Global fields are never indexed.