![]() ![]() (Scripting in FileMaker is macrolike: You choose a sequence of actions from a list and specify parameters rather than writing actual code.) This simplistic approach will seem tedious if you're already comfortable with Boolean queries or SQL, and in order to save a query for later use, you must enlist FileMaker's scripting capability. You simply fill in fields in a form with the criteria you want to search for, and then you can incrementally revise queries to extend or constrain the original result set. For more specialized validation logic, a full-blown expression editor is available, too. We found defining field validation rules simple, because FileMaker offers choices for common cases-such as ensuring that a number is within a particular range or that a text field contains predefined or derived values-directly through its interface. We were easily able to set up relationships between tables, create reports based on the relationships, and use the WYSIWYG layout tool to embed a "portal" that exposed fields from records in another table in an input form. In fact, it uses the term database to refer to a single data table and its associated information, such as layouts. ![]() At first glance, FileMaker looks deceptively like a flat-file database. (For more on FileMaker Mobile, see the sidebar below.) Finally, the FileMaker Web Server Connector runs on Red Hat Linux 7.1.įileMaker successfully masks much of the complexity that underlies common tasks. And FileMaker Mobile 2.1 runs on Palm and Pocket PC devices, letting individual users synchronize data with their desktops. Experienced database jockeys may be more comfortable with software that exposes advanced capabilities more directly, but FileMaker is ideal for novice-to-midrange database users who don't want to mess with the intricacies of a product like Microsoft Access.įileMaker is also versatile: It runs both on Windows and on Apple Mac OS 8.6 or later (natively on Mac OS X). ![]() ![]() Yet its interface is truly easy to use, whether you're designing forms and reports or publishing a database on the Web-which, by the way, only takes a click on a single check box. With support for relationships between tables, fine-grained user privileges, XML import and export, and basic scripting, FileMaker includes the features you need for building lots of different kinds of business applications. FileMaker Pro 6 proves that a highly capable desktop database needn't be complex and intimidating. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |