Chapter 1
|
Introduction 15
IsValidExpression 137
KanaHankaku 171
KanaZenkaku 172
KanjiNumeral 172
Katakana 172
L, M, N, O
Last 157
LayoutIDs 49
LayoutNames 50
LayoutObjectNames 50
Left 173
LeftValues 173
LeftWords 174
Length 175
Let 138
Lg 148
List 20
Ln 149
Log 149
Lookup 140
LookupNext 141
Lower 175
Max 21
Middle 176
MiddleValues 176
MiddleWords 177
Min 22
Minute 202
Mod 150
Month 35
MonthName 36
MonthNameJ 36
NPV 60
NumToJText 178
P, Q
PatternCount 179
Pi 209
PMT 61
Position 179
Proper 180
PV 62
Quote 181
R
Radians 210
Random 150
RelationInfo 51
Replace 181
RGB 192
Right 182
RightValues 182
RightWords 183
-
FileMaker
1
-
Contents
3
-
Contents 5
5
-
Logical functions 127
6
-
Contents 7
7
-
Text functions 161
8
-
Contents 9
9
-
Chapter 1
11
-
Introduction
11
-
Introduction 13
13
-
H, I, J, K
14
-
L, M, N, O
15
-
V, W, X, Y, Z
16
-
Chapter 2
17
-
Aggregate functions
17
-
Aggregate functions 19
19
-
Aggregate functions 21
21
-
Aggregate functions 23
23
-
Variance
27
-
VarianceP
28
-
Chapter 3
31
-
Date functions
31
-
Date functions 33
33
-
DayNameJ
34
-
DayOfWeek
34
-
DayOfYear
35
-
MonthName
36
-
MonthNameJ
36
-
WeekOfYear
37
-
WeekOfYearFiscal
37
-
YearName
39
-
Chapter 4
41
-
Design functions
41
-
DatabaseNames
43
-
FieldBounds
43
-
FieldComment
44
-
FieldIDs
45
-
FieldNames
45
-
FieldRepetitions
46
-
FieldStyle
47
-
FieldType
48
-
GetNextSerialValue
49
-
LayoutIDs
49
-
LayoutNames
50
-
LayoutObjectNames
50
-
RelationInfo
51
-
ScriptIDs
52
-
ScriptNames
53
-
TableIDs
53
-
TableNames
54
-
ValueListIDs
54
-
ValueListItems
55
-
ValueListNames
55
-
WindowNames
56
-
Chapter 5
57
-
External functions
57
-
External
58
-
Chapter 6
59
-
Financial functions
59
-
Chapter 7
63
-
Get functions
63
-
Get functions 65
65
-
Get functions 67
67
-
Get(AccountName)
68
-
Get(ActiveFieldContents)
68
-
Get(ActiveFieldName)
69
-
Get(ActiveFieldTableName)
69
-
Get(ActiveLayoutObjectName)
70
-
Get(ActiveModifierKeys)
71
-
Get(ActiveRepetitionNumber)
71
-
Get(ActiveSelectionSize)
72
-
Get(ActiveSelectionStart)
72
-
Get(AllowAbortState)
73
-
Get(AllowToolbarState)
73
-
Get(ApplicationLanguage)
74
-
Get(ApplicationVersion)
75
-
Get(CurrentDate)
76
-
Get(CurrentHostTimestamp)
76
-
Get(CurrentTime)
77
-
Get(CurrentTimestamp)
78
-
Get(CustomMenuSetName)
78
-
Get(DesktopPath)
79
-
Get(DocumentsPath)
80
-
Get(ErrorCaptureState)
80
-
Get(ExtendedPrivileges)
81
-
Get(FileMakerPath)
81
-
Get(FileName)
82
-
Get(FilePath)
82
-
Get(FileSize)
83
-
Get(FoundCount)
84
-
Get(HighContrastColor)
84
-
Get(HighContrastState)
85
-
Get(HostIPAddress)
85
-
Get(HostName)
86
-
Get(LastError)
87
-
Runtime errors
88
-
Get functions 89
89
-
Get functions 91
91
-
Get(LastMessageChoice)
93
-
Get(LastODBCError)
94
-
Get(LayoutAccess)
94
-
Get(LayoutCount)
95
-
Get(LayoutName)
96
-
Get(LayoutNumber)
96
-
Get(LayoutTableName)
97
-
Get(LayoutViewState)
97
-
Get(MultiUserState)
98
-
Get(NetworkProtocol)
99
-
Get(PageNumber)
99
-
Get(PortalRowNumber)
100
-
Get(PreferencesPath)
100
-
Get(PrinterName)
101
-
Get(PrivilegeSetName)
102
-
Get(RecordAccess)
102
-
Get(RecordID)
103
-
Get(RecordModificationCount)
104
-
Get(RecordOpenCount)
105
-
Get(RecordNumber)
105
-
Get(RecordOpenState)
106
-
Get(RequestCount)
107
-
Get(RequestOmitState)
107
-
Get(ScreenDepth)
108
-
Get(ScreenHeight)
108
-
Get(ScreenWidth)
109
-
Get(ScriptName)
109
-
Get(ScriptParameter)
110
-
Get(ScriptResult)
111
-
Get(SortState)
112
-
Get(StatusAreaState)
112
-
Get(SystemDrive)
113
-
Get(SystemIPAddress)
114
-
Get(SystemLanguage)
114
-
Get(SystemNICAddress)
115
-
Get(SystemPlatform)
115
-
Get(SystemVersion)
116
-
Get(TextRulerVisible)
116
-
Get(TotalRecordCount)
117
-
Get(UserCount)
117
-
Get(UserName)
118
-
Get(UseSystemFormatsState)
119
-
Get(WindowContentHeight)
119
-
Get(WindowContentWidth)
120
-
Get(WindowDesktopHeight)
120
-
Get(WindowDesktopWidth)
121
-
Get(WindowHeight)
122
-
Get(WindowLeft)
122
-
Get(WindowMode)
123
-
Get(WindowName)
123
-
Get(WindowTop)
124
-
Get(WindowVisible)
125
-
Get(WindowWidth)
125
-
Get(WindowZoomLevel)
126
-
Chapter 8
127
-
Logical functions
127
-
Evaluate
129
-
EvaluationError
131
-
GetAsBoolean
131
-
GetField
132
-
GetLayoutObjectAttribute
133
-
GetNthRecord
134
-
Logical functions 135
135
-
IsValidExpression
137
-
Logical functions 139
139
-
LookupNext
141
-
1 to 4
142
-
Chapter 9
143
-
Number functions
143
-
Combination
145
-
Factorial
146
-
Number functions 147
147
-
Ln number()
148
-
SetPrecision
151
-
Truncate
153
-
Chapter 10
155
-
Repeating functions
155
-
GetRepetition
156
-
Repeating functions 157
157
-
Chapter 11
159
-
Summary functions
159
-
GetSummary
160
-
Chapter 12
161
-
Text functions
161
-
Text functions 163
163
-
FilterValues
164
-
GetAsCSS
165
-
GetAsDate
166
-
GetAsNumber
166
-
GetAsSVG
167
-
GetAsText
168
-
GetAsTime
168
-
GetAsTimestamp
169
-
GetAsURLEncoded
169
-
GetValue
170
-
Hiragana
171
-
KanaHankaku
171
-
KanaZenkaku
172
-
KanjiNumeral
172
-
Katakana
172
-
LeftValues
173
-
LeftWords
174
-
Text functions 175
175
-
MiddleValues
176
-
MiddleWords
177
-
NumToJText
178
-
PatternCount
179
-
Position
179
-
Text functions 181
181
-
RightValues
182
-
RightWords
183
-
RomanHankaku
184
-
RomanZenkaku
184
-
SerialIncrement
185
-
Substitute
186
-
Text functions 187
187
-
ValueCount
189
-
WordCount
189
-
Chapter 13
191
-
Text formatting functions
191
-
TextColor
192
-
TextColorRemove
193
-
TextFont
194
-
TextFontRemove
195
-
TextFormatRemove
196
-
TextSize
197
-
TextSizeRemove
197
-
TextStyleAdd
198
-
TextStyleRemove
199
-
Chapter 14
201
-
Time functions
201
-
Time functions 203
203
-
Examples
204
-
Chapter 15
205
-
Timestamp functions
205
-
Timestamp
206
-
Chapter 16
207
-
Trigonometric functions
207
-
Appendix A
213
-
Glossary
213
-
Glossary 215
215
-
Glossary 217
217
-
Glossary 219
219
-
Glossary 221
221
-
Glossary 223
223
-
Glossary 225
225
-
Glossary 227
227
-
Glossary 229
229
-
Glossary 231
231
-
Glossary 233
233
-
Glossary 235
235
-
W, X, Y, Z
237
Commentaires sur ces manuels