Functions Reference

U
F
ILEMAKER PRO FUNCTIONS REFERENCE 380
Table
A collection of data pertaining to a sub
ject, such as customers or stock prices. A database
contains one or more tables, which consist of fields and records. When you create a new table,
a visual representation, or occurrence, of the table appears in the relationships graph. You can
specify multiple table occurrences (with unique names) of the same table in order to work with
complex relationships in the graph.
Table View
Displays multiple records in a t
abular format like a spreadsheet. Each record appears in a row,
and each field appears in a column. To select this view, click Table View in the layout bar.
In Browse mode, you can use Table View to create, modify, and delete
fields; choose field types;
add, delete, and sort records; or create a chart or dynamic report.
Target file
The file into which you bring dat
a during importing or exporting.
TCP/IP (Transmission Control Protocol/Internet Protocol)
The basic communication protocol th
at is the foundation of the Internet.
Template
A predefined website that you can select in the Web Viewer Setup
dialog box to help you create
a web viewer quickly.
Text baseline
In Layout mode, the guideline that a
ppears at the base of the text in a field or text block. Text
baselines can be solid, dotted, or dashed. If you want text baselines to also appear in Browse
and Find modes, select Text baselines in the Appearance
tab in the Inspector.
Text expression
Any expression that returns a text
result. For example, a text expression can be a constant
("London"), a field reference (Status), or a calculated value (Rightwords(Lastname;1)).
Timestamp
A field type combining date and time that is compatible with the
ODBC requirement for the SQL
format [yyyy.mm.dd hh:mm:ss.sss].
Tooltip
A small box that displays text when a user
moves the cursor over a layout object. Tooltips
display in Browse, Find, and Layout modes.
U
Unicode
A worldwide standard that, in one cod
e page, provides a unique number for every character in
human languages, no matter what the platform, software program, or operating system.
Unit of measure
In Browse and Layout modes, you can
set the unit of measure to points, inches, or centimeters.
Unstored calculation
A calculation field with a result that is only calculated when the
value is needed, for example, to
browse or print. In most cases, FileMaker Pro makes a field stored when
you define it, but you
can change the storage type to unstored.