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 that you'll make a mistake or permit something undesirable to happen. So it's necessary to have a firm grasp of FileMaker's data types, and how each of them works and relates to the others.

: FileMaker Specifications

FileMaker 8 Product Line

Specifications and Storage Limits

Field Types and Import/Export Formats

: Calculation Functions

Working with Calculations Primer

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

Script Step Reference

: Quick Reference

FileMaker Error Codes

FileMaker Keyboard Shortcuts

FileMaker Network Ports

FileMaker Server Command Line Reference

FileMaker XML Reference

: Other Resources

Where to Go for More Information

FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352 © 2008-2020.
If you may any questions please contact us: