Index_G

F

false() XPath function, 316

FIELD element, 47, 49, 56, 60, 71-73, 116-117, 124, 301, 313, 318, 326, 329, 331, 333, 335

FMPXMLRESULT, 47

for Import XML, 73

related fields, 56

field names, 32

relationship to element names, 91

field order for export, 45, 46, 49, 55, 63

fields, see also calculated fields, container

fields, date fields, global fields, merge

fields, number fields, related fields,

repeating fields, summary fields, value list

fields size limit, 82, 87

specify for export, 45

time, formats on layout, 61, 63

types in FileMaker Pro, 13

validation in FileMaker Pro, 13-15

file Internet protocol, 33

file sharing, 176, 205, 225

FileBooks Link (HAPPY Software), 68

plug-in, 8

FileMaker Developer, 113, 131, 133, 135, 163-165, 167, 279, 287

FileMaker Pro

define fields, 13

export text formats, 9

field validation, 13-15

import XML, 68

standard themes, 100

text formats, 2-5, 8-9, 63

theme files, 98

FileMaker Pro functions

Case(), 62, 79-80, 85, 106, 191, 309-310

Choose(), 309

Left(), 40, 62, 314-315

Middle(), 40

PatternCount(), 83-85

Position(), 62, 84-85, 315

Status(CurrentError), 46, 115, 121, 233

Status(CurrentFileName), 64, 92, 121, 181, 191

Status(CurrentRecordCount), 49, 119, 313

Status(CurrentRecordID), 46, 126, 196, 206

Status(CurrentRecordModificationCount), 46, 126, 196

Status(CurrentRecordNumber), 79-80, 82, 313

Substitute(), 85, 92, 316

Trim(), 85, 315

ValueListItems(), 64

ValueListNames(), 64

ValueListNames (Status (CurrentFileName)), 64

Web-ToHTTP, 92

FileMaker Pro layout part

Body, 104-105

FileMaker Pro layouts, themes, 89

FileMaker Pro Unlimited, 157, 164-165, 167, 175-176, 178-180, 235, 287, 296

FileMaker Pro Web Publishing and UTF-8, 16

FileMaker Server, 159, 163, 165-167, 175-176, 178, 226, 279

find

duplicate a record, 199

Enter Find Mode, 212

ERRORCODE, 233, 234

find records, 185-186

optional with -lay, 191

-recID optional, 182, 184

records, 185-186

request parameters, 197-201

and -script, 203, 215

with form submit, 285, 286

with -recid, 195

with -sort, 202

find a random record

-findany, 185, 191, 232, 234, 286

find all records

-findall, 185, 191, 232, 234, 286

-find, optional

-recID, 185-186

find records

-find, 185-186

-findall

find all records, 185, 191, 232, 234, 286

-findany

find a random record, 185, 191, 232, 234, 286

#FIXED DTD, 96

fixed-length format data exchange, 8

flexible, 7, 10, 47, 49, 130, 255-256, 265

floor() XPath function, 316

-fmp_dso

-format, 211, 295, 297

-fmp_dso_dtd

-format, 193

-fmp_xml

-format, 113, 123, 211, 296

-fmp_xml_dtd

-format, 194

FMPDSORESULT

DATABASE, 46

!ELEMENT, 194-195

ERRORCODE, 46

grammar, 9, 49

LAYOUT, 46

MODID, 46, 126, 234, 311

RECORDID, 46

related fields, 52, 54, 57, 60

ROW, 46

spaces converted to underscore, 91

XML export, 44, 46

FMPDSORESULT vs. FMPXMLRESULT 49

FMPXMLLAYOUT

-lay, -view, 114-115, 187, 195, 284

merge fields, 119

FMPXMLRESULT

COL, 49, 53

DATA, 47

DATABASE, 47

DATEFORMAT, 48

FIELD, 47

grammar, 9, 49

import XML, 68, 70

LAYOUT, 49

METADATA, 47

PRODUCT, 47-48

RECORDS, 49

related fields, 52, 53, 55, 59

ROW, 47

TIMEFORMAT, 48

XML export, 47

FMPXMLRESULT vs. FMPDSORESULT, 49

footer

tfoot, HTML table, 257

theme part, 100, 105

form HTML element, 238, 263, 275-276, 278-281, 285-286

form select element

option, 200, 275, 277-278

form submit

-find, 285-286

-format

errors with CDML, 233, 235

-fmp_dso, 211, 295, 297

-fmp_dso_dtd, 193

-fmp_xml, 113, 123, 211, 296

-fmp_xml_dtd, 194

required with -dbnames, 187

required with -layoutnames, 188

required with -new, 183

required with -view action for layout information, 186

-format, CDML

name of format file, 192, 286-287

format output using current layout 46, 49, 61, 63, 325

-format, XML

returns namespace, 296

XML format to return, 113, 123, 183, 186-188, 192, 211, 286-287, 296

formats by calculation

fields, number, 62

formats on layout

date fields, 61-62

number fields, 61

time fields, 61, 63

value list fields, 64

formatted text

XML export, 63

frame HTML element, 266, 267, 274

frameset

DOCTYPE, 219, 239

HTML element, 262

.fth, theme file extension, 97

ftp Internet protocol, 33, 34, 175, 177, 275

functions, XPath, 40, 292, 312-317, 345, 350, 353