Functions Reference

D
F
ILEMAKER FUNCTIONS REFERENCE 370
Data point
In a chart, the value of data plotted on the x or y axis displayed as a column, bar, point, bubble,
or slice.
Data series
Data points that are plotted in a chart. When multiple data series are charted, each data series
is displayed in a unique color and is defined in the chart’s legend, if included.
Data source
A named reference that provides access to another FileMaker file or to an ODBC database.
ODBC data sources are also referred to as external SQL sources (ESS).
In charting, the origin of the data to be charted — current found set, current record (delimited
data), or related records.
Data source name (DSN)
A data structure that contains the information about a specific file that an ODBC driver needs in
order to connect to it.
Data Viewer
A FileMaker Pro Advanced feature that lets you monitor expressions such as field values, local
and global variables, and calculations. You can monitor expressions while running scripts or
while testing them in the Script Debugger. You can also monitor field values and variables in the
file.
Database file
A component of a FileMaker solution.
Database
The arrangement of tables and fields and their interrelationships in a file.
Database Design Report
A FileMaker Pro Advanced tool that creates a report of your database schema.
Database Encryption
A form of encryption that protects “data at rest.” For FileMaker, data at rest is a FileMaker Pro
file, and its temporary files, while it is being stored on disk (and not open). An encrypted file is
protected from unauthorized access with an encryption password. FileMaker
Pro Advanced is
required to encrypt files. Encrypted files can be decrypted and re-encrypted as needed.
Database Management System (DBMS)
An application that allows users to store, process, and retrieve information in a database.
Descending sort order
Reverse alphabetical sequence (Z to A) for words, highest to lowest order for numbers, and
latest to earliest dates and times.
Developer Utilities
A FileMaker Pro Advanced feature that lets you bind files into a runtime solution, display files in
Kiosk mode, prevent users from modifying the design or structure of databases, and
automatically rename sets of files and update links to related files.
Dialog window
A document window in a modal state. Its behavior is similar to the behavior of a window when a
running script is paused. You can create and customize a dialog window using the New Window
script step.