<?xml version="1.0" encoding="ISO-8859-1"?>
<html xmlns="http://www.w3.org/1999/xhtml"><head xmlns="http://www.w3.org/1999/xhtml"><title xmlns="http://www.w3.org/1999/xhtml">Field Types</title><meta xmlns="http://www.w3.org/1999/xhtml" name="generator" content="DocBook XSL Stylesheets V1.50.0"/><link rel="home" href="index.html" title="Pilot-DB Users Manual"/><link rel="up" href="ch04.html" title="Chapter 4. Creating a Database"/><link rel="previous" href="ch04s02.html" title="Creating a field"/><link rel="next" href="ch05.html" title="Chapter 5. Working with a Database"/></head><body><div xmlns="http://www.w3.org/1999/xhtml" class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Field Types</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch04s02.html">Prev</a> </td><th width="60%" align="center">Chapter 4. Creating a Database</th><td width="20%" align="right"> <a accesskey="n" href="ch05.html">Next</a></td></tr></table><hr/></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h2 class="title" style="clear: both"><a xmlns="http://www.w3.org/1999/xhtml" id="fieldtypes.sect"/>Field Types</h2></div></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2764993"/>Text Fields</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     This field corresponds to a line of up to 256 editable characters <i xmlns="http://www.w3.org/1999/xhtml">including the linefeed.</i>
    </p></fake><fake><p xmlns="http://www.w3.org/1999/xhtml">
     For this type of field, it is possible to set a default value.
    </p></fake></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2764982"/>Memo Fields</h3></div></div><div xmlns="http://www.w3.org/1999/xhtml" class="warning" style="margin-left: 0.5in; margin-right: 0.5in;"><h3 class="title">Warning</h3><fake><p xmlns="http://www.w3.org/1999/xhtml"> There may only be a single field of this type defined in a record.</p></fake></div><fake><p xmlns="http://www.w3.org/1999/xhtml">This field is similar to a note that you add in the Address application. It contains a 32-character title and an editable note displayed in a new window. This note may contain up to 3000 editable characters,<i xmlns="http://www.w3.org/1999/xhtml">including the linefeed</i>.</p></fake></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2765066"/>Integer Fields</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     This type of field may only contain an integer, i.e., numeric characters and a sign.
    </p></fake><fake><p xmlns="http://www.w3.org/1999/xhtml">
     You may enter values in decimal, octal or hexadecimal form, but the display will only show the values in decimal form:
    </p></fake><pre xmlns="http://www.w3.org/1999/xhtml" class="screen">
     1234567890
     01234567
     0x123456789ABCDEF0
    </pre><fake><p xmlns="http://www.w3.org/1999/xhtml">
     It is possible to set a default value and an increment for a field of this type. If the increment is zero, the default value is assigned to each record of the database. If the increment is not zero, the increment is progressively added to the default value each time a new record is created or duplicated. This new value is then assigned to the record being created and becomes the default value for the next record.
    </p></fake></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2765104"/>Real Number Fields</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     This field type contains digits, a decimal point and an optional <i xmlns="http://www.w3.org/1999/xhtml">+ or -</i> sign.
    </p></fake><fake><p xmlns="http://www.w3.org/1999/xhtml">
     A default value may be set in a field of this type.
    </p></fake></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2765141"/>Calculated Fields</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     A field of this type contains a <a xmlns="http://www.w3.org/1999/xhtml" href="">script</a>, which enables a calculation based on values in other fields.
    </p></fake><fake><p xmlns="http://www.w3.org/1999/xhtml">
     The contents of the field may not be directly edited. If you have edited the values of the fields used in the script, tap on it to update the result. Be aware; however, for certain scripts that calculate values depending on other records, the result is not updated directly - only the record list is updated. To ensure complete updating, open the Register? menu and tap on Recalculate All. Depending on the number of records involved, this may take some time.
    </p></fake><div xmlns="http://www.w3.org/1999/xhtml" class="screenshot"><div xmlns="http://www.w3.org/1999/xhtml" class="mediaobject"><img src="figures/mlistview1.png"/></div></div></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2765243"/>Date Fields</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     This field type contains a date, which may be selected from a calendar. The display depends on your preferences as declared in Preferences.
    </p></fake><fake><p xmlns="http://www.w3.org/1999/xhtml">
     A default value may be set in a field of this type. It is also possible to set today's date as default in a new record.
    </p></fake></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2765274"/>Time Fields</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     This field type contains a time <i xmlns="http://www.w3.org/1999/xhtml">in hours and minutes</i>. Display will be according to the preferences set in the Preferences application.
    </p></fake><fake><p xmlns="http://www.w3.org/1999/xhtml">
     A default value may be set in a field of this type. It is also possible to set the time of creation of a new record as default.
    </p></fake></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2827356"/>Drop-Down List Fields</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     This field type allows the user to have a list of character strings, each set in advance and then to select one of these strings when creating or editing a record.
    </p></fake></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2827380"/>Link Fields (to Another Database)</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     This field is a link to a record in the same or a different database. The field displays the contents of the linked record. The field is selected when creating the database.
    </p></fake></div><div xmlns="http://www.w3.org/1999/xhtml" class="section"><div xmlns="http://www.w3.org/1999/xhtml" class="titlepage"><div xmlns="http://www.w3.org/1999/xhtml"><h3 class="title"><a xmlns="http://www.w3.org/1999/xhtml" id="id2827406"/>Linked Fields</h3></div></div><fake><p xmlns="http://www.w3.org/1999/xhtml">
     This field type is the inverse of the previous one. It is used when the user wants to view more than one field of a linked record. This type of field can only be created subsequent to the link which works with it.
    </p></fake></div></div><div xmlns="http://www.w3.org/1999/xhtml" class="navfooter"><hr/><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ch04s02.html">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="ch04.html">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="ch05.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Creating a field </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Chapter 5. Working with a Database</td></tr></table></div></body></html>
