Filemaker TH325Z/A manuály

Filemaker TH325Z/A Datový list (238 strany)

Značka: Filemaker | Kategorie: Databázový software | Velikost: 1.84 MB |

Angličtina

Tabulka s obsahem

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

Další produkty a příručky pro Databázový software Filemaker

Modely	Typ Dokumentu
TT761E/A	Datový list Filemaker Pro 10, 21 stránky
Server 10	Instalační příručka Filemaker Server 10 [da] [de] [es] [et] [fr] [it] [nl] , 66 stránky
H2804LL/A	Datový list Filemaker Pro 11, MNT, 500-999s, 1Y, 20 stránky
TU650LL/A	Datový list Filemaker Server 11 VLA, 5 stránky
TU689LL/A	Datový list Filemaker Pro 10, 82 stránky
TH326Z/A	Datový list Filemaker Upgrade to Pro v8.5, 1 stránky

Filemaker zařízení