Filemaker TH325Z/A Ficha de datos Pagina 141
- Pagina / 238
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Chapter 8
|
Logical functions 141
LookupNext
Format
LookupNext(sourceField;lower/higherFlag)
Parameters
sourceField - the field from which the lookup value is taken.
lower/higherFlag - the keywords lower or higher denote whether the value from
the next lower/higher matching record must be taken if the lookup fails.
Data type returned
text, number, date, time, timestamp, container
Description
Returns the value specified in sourceField using the relationships in the relationships
graph. If the lookup fails, the value from the source field in the next lower or higher
matching record will be returned, as specified by lower/higherFlag. In order for this
function to access the value in sourceField, the tables containing the source field and
calculation field need to be related. Calculations using the LookupNext function won’t be
forced to be unstored calculations.
Example
There are two tables, People and Company, in a database file containing data as shown
below.
People table
Company table
CompanyID Employee
100 John Smith
200 Peter Wong
300 Sally Anderson
377 Mary MacKenzie
CompanyID CompanyName Code
100 Apple 91234
100 Apple 82345
200 FileMaker 95054
300 Motorola 93456
400 Cisco 88123
- 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
Relacionado con productos y manuales para Software de base de Filemaker TH325Z/A
(21 paginas)© 2020, manymanuals.es. Todos los derechos reservados | 0.082 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales