Chapter 3. Field Types and Import/Export Formats

Knowing Your Data

Besides just knowing the raw statistics and capacities of your software tools (“speeds and feeds,” as the machinists like to say), it’s wise to understand the basic data formats with which your database software can work. In this chapter we give a brief overview of each of the underlying FileMaker field data types, and we also discuss the various data formats available for import and export.

First, a word about data types in FileMaker: Unlike certain other database engines, FileMaker is somewhat forgiving about data types. You can add text characters to a number field, for example, without being stopped by FileMaker. The price you pay for this flexibility is the possibility ...

Get FileMaker® 8 Functions and Scripts Desk Reference now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.