User manual

Table Of Contents
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