User manual
Table Of Contents
- Preface Introducing FileMaker Pro
- Chapter 1 Using databases
- About database fields and records
- Opening files
- Opening multiple windows per file
- Closing windows and files
- Saving files
- About modes
- Viewing records
- Adding and duplicating records
- Deleting records
- Entering data
- Finding records
- Making a find request
- Performing quick finds based on data in one field
- Finding text and characters
- Finding numbers, dates, times, and timestamps
- Finding ranges of information
- Finding data in related fields
- Finding empty or non-empty fields
- Finding duplicate values
- Finding records that match multiple criteria
- Finding records except those matching criteria
- Deleting and reverting requests
- Viewing, repeating, or changing the last find
- Hiding records from a found set and viewing hidden records
- Finding and replacing data
- Sorting records
- Previewing and printing databases
- Automating tasks with scripts
- Backing up database files
- Setting preferences
- Chapter 2 Creating databases
- Chapter 3 Working with related tables and files
- Chapter 4 Sharing and exchanging data
- Sharing databases on a network
- Importing and exporting data
- Saving and sending data in other formats
- Sending email messages based on record data
- Supported import/export file formats
- ODBC and JDBC
- Methods of importing data into an existing file
- About adding records
- About updating existing records
- About updating matching records
- About the importing process
- Converting a data file to a new FileMaker Pro file
- About the exporting process
- Publishing databases on the web
- Chapter 5 Protecting databases with accounts and privilege sets
- Chapter 6 Converting FileMaker databases from previous versions
- Index
108 FileMaker Pro User’s Guide
Switching windows in scripts
When necessary, pre-7.0 versions of FileMaker Pro would
automatically change the active window after running a script. This
automatic windowing behavior is no longer supported because script
writers can use the Select Window script step to set the active window.
To emulate the behavior of pre-7.0 versions, during file conversion
FileMaker Pro
8 automatically inserts Select Window script steps
after certain Perform Script and Go to Related Record script steps. To
achieve the windowing behavior you want, you may need to insert or
delete Select Window script steps.
Boolean functions and find requests
Because FileMaker Pro 7 and 8 do not recognize previously supported
alphabetic characters in a number field as numbers, some logical
functions that return Boolean true/false results may return the wrong
results. Also, some find requests for Boolean content may return
different results than in pre-7.0 versions of FileMaker
Pro.
The following table shows how Boolean results can differ.
If you have used “Yes” or “T” or other text to mean true in number
fields, Boolean calculations relying on these characters will not return
results consistent with pre-7.0 versions of FileMaker Pro.
Find requests for Boolean information are also more restrictive. For
example, in a pre-7.0 release of FileMaker Pro, a find request in a
number field for
True would find the values 1, True, Yes, Y, y, T, or
t. In FileMaker Pro
7 and 8, this find request would only find the value
True. You can modify your find request to make the found set match
what was returned in previous releases. You can also use the
Find/
Replace
command to make your data consistent.
File references
A file reference stores the paths that FileMaker Pro searches to access
an external FileMaker file. File references are present but not visible
in pre-7.0 versions of FileMaker Pro, but in FileMaker Pro
7 and 8
you can view and edit them in the Define File References dialog box.
The following are two file reference conversion issues that may occur:
1 After conversion of a multi-file solution, the files open very
slowly. It’s possible that file references are pointing to external
locations. You can increase the speed with which files open by
resetting file references to local paths, if possible. Also look for file
references that contain asterisks in the path, which indicates that the
file reference is searching your network for the file. Replace the
asterisk with an IP Address or domain name of the computer on which
the remote file resides.
1 After conversion, the Define File References dialog box
contains multiple versions of the same file reference. You can
manually consolidate the file references if you want. The most
efficient way to do this is to create a new file reference and then edit
relationships, scripts, value lists, and any other items that may refer to
that file to use the new file reference. Then delete all of the old file
references that are identical to it.
Number field content
In FileMaker Pro 8
and FileMaker Pro 7,
evaluates to
In FileMaker Pro 6 and
earlier, evaluates to
blank field False False
0 False False
1 True True
True, Yes, Y, y, T, or t False True
False, No, N, n, F, or f False False