Database Reference
In-Depth Information
Figure 13-10. Two steps (the Perform Script steps at the top) in this script have been turned off, as
you can see by the double slashes in front of the names. When a script step you turned off is selec-
ted, the Disable button reads Enable. FileMaker skips the steps you turned off when the script runs.
Turning script steps off is useful for debugging, but it can have long-term use, too. Any step
you turn off in FileMaker Pro Advanced gets skipped whenever someone runs it—even in
FileMaker Pro.
WORD TO THE WISE: KEEPING WATCH
Some functions are very handy to keep in your Data Viewer's Watch tab all the time. When debug-
ging a multifile or multiuser database, consider giving these expressions long-term residency:
▪
Get (FilePath)
. Shows the name of the current database and where it resides on your drive or
which server is hosting it.
▪
Get (AccountName)
. The account you're currently logged in with.
▪
Get (AccountPrivilegeSetName)
. Your current privilege set.
▪
Get (LastError)
. Lets you see errors even when the Script Debugger is closed.
▪
Get (LayoutName)
. For those times the toolbar is hidden.
▪
Get (LayoutTableName)
. Displays the name of the table occurrence the current layout is based
on.
▪
Get (WindowWidth)
and
Get (Window Height)
. Useful to keep an eye on when designing a
database for someone with a smaller screen than you.