• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1:How significant is FileMaker 7?
A1: This book was written from the ground up for FileMaker 7. Most of the concepts in the book and in FileMaker are not new; they have stood the test of time. But other features of FileMaker 7 are radical departures—particularly the idea of having several tables in one file. Also important and different in FileMaker 7 are the unified security model and the handling of file references. Major enhancements to scripting and Instant Web Publishing also are present.

If you are an old hand at FileMaker, you can adopt FileMaker 7 in most cases by simply opening your old databases in FileMaker 7: It does the conversion for you automatically. However, you will not automatically take advantage of the new features. Take some time to look at the new features so that when you start your next project (or do maintenance work on an existing project) you can use these new features.

Q2:As you develop solutions with FileMaker and become more and more dependent on it, what is the best way to protect that investment?
A2: There are several answers to this. The first one is document, document, document. Use comments (including the new comment feature for fields in the database) all over the place. A year from now, you will not remember why you did things one way or another.

Nor will you remember the difference between the field SalesTotal and TotalSales. Comments can help, but standard naming conventions can also help. A script that edits data but has no user interaction might be called EditLineItem. The script that runs EditLineItem and provides a message dialog to display whatever message was generated could be DoEditLineItem. If you adopt such a naming convention, make it consistent. (And as you modify your existing solutions, start to rename fields, scripts, and layouts without modifying them to bring the nomenclature into a standard form.)

And finally, treat your FileMaker solutions like the valuable tools that they are. FileMaker makes it easy to make modifications, but even if you are a one-person operation, resist the temptation to tweak the solution every time you run it. If you are the developer as well as the user, try to keep those two roles distinct.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint