Database Reference
In-Depth Information
NOTE
Even if you don't use a “Go to Field” script step for a specific field, a field may be listed in the
scripts column.
Go to Related Record
, or any other step that uses a relationship, also requires the use
of that relationship's key field, so it also has that field as a dependency.
Finding Broken Elements with the DDR
Suppose you've deleted a field, unaware that it's used in a script. Your script could be run
numerous times, not
quite
working, without your knowledge. The DDR is a great way to
check for errors like this. Say, for example, you unwittingly delete a field used in a script. If
you open the script to edit it, then you can see the words “<Field Missing>” right in the
script:
Set Field [Expenses::<Field Missing>; "==" & Get ( ScriptParameter )]
To spot every error like this, though, you have to open every script and read through it.
FileMaker has no facility to let you search through your scripts.
But you
can
search the DDR page in your web browser. (Pressing Ctrl+F or
⌘
-F does the
trick in most browsers.) In the Find field, type the text you're looking for and then click Next
(or whatever button your browser uses) to start the search. You see the first instance of your
search criteria highlighted. Click the button again to find other instances.
The whole list of errors you might search for appears below. If you have any inkling what
kind of error you're looking for, start with that one:
▪
<unknown>
. This is a catch-all for lost references.
▪
<Missing Field>
. Referenced field is missing.
▪
<Missing Table Occurrence>
. Referenced table occurrence set is missing.
▪
<Missing Base Table>
. Referenced base table is missing.
▪
<Missing File Reference>
. Referenced file reference is missing.
▪
<Missing Layout>
. Referenced layout is missing.
▪
<Missing Valuelist>
. Referenced value list is missing.
▪
<Missing Custom Function>
. Referenced custom function is missing.
▪
<Missing Script>
. Referenced script is missing.
▪
<Missing Account>
. Referenced account is missing.
