Quick Start
Table Of Contents
- Chapter 1 Welcome to FileMaker Pro
- Chapter 2 Installing FileMaker Pro in Windows
- Chapter 3 Installing FileMaker Pro in the Mac OS
- Chapter 4 New features in FileMaker Pro
- New features in FileMaker Pro 5.5
- Windows 2000 Professional
- Ease-of-use improvements
- Record-by-record access privileges
- Scripting improvements
- New logical, design, and status functions
- Extended ODBC and SQL functionality
- Import named ranges of Microsoft Excel data
- Search only the relative path for FileMaker Pro files
- Relaxed rules for mapping fields and relationships when importing scripts
- Dynamic field name matching in data import scripts
- Import more graphics file formats
- Increased productivity with FileMaker Server
- Prevent users from changing passwords
- Prevent users from creating databases
- Validation of the number of characters in a field
- Open a FileMaker Pro database via a URL (Mac OS)
- Web publishing enhancements
- Backward compatibility
- New features in FileMaker Pro 5
- Hands-on, task-oriented tutorial
- New features in FileMaker Pro 5.5
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Lesson 4 Creating a database and entering records
- Lesson 5 Customizing what you see
- Lesson 6 Creating lists, mailing labels, and form letters
- Lesson 7 Simplifying data entry
- Lesson 8 Automating tasks with buttons and scripts
- Lesson 9 Creating and running reports
- Lesson 10 Making databases relational
- Lesson 11 Keeping your data safe
New features in FileMaker Pro 31
1 Status (CurrentRecordAccess)
1 Status (CurrentStatusArea)
1 Status (CurrentView)
1 Status (CurrentWebSharing)
See FileMaker Pro Help for details about these functions.
Extended ODBC and SQL functionality
FileMaker Pro 5.5 gives you more control over how you interact with
ODBC data sources. FileMaker Pro 5 introduced the ability to query
ODBC data. Now you can use FileMaker Pro 5.5 to execute SQL
statements. This ability to export data and manipulate tables
enhances FileMaker Pro integration with enterprise data sources
such as Oracle, SAP, and Microsoft SQL Server.
FileMaker Pro 5.5 has a new Status(CurrentODBCError) function
that returns a string displaying the error state published by ODBC
standards (based on ISO/IEF standards).
Execute any SQL statement via FileMaker Pro script
FileMaker Pro 5.5 introduces the Execute SQL script step, which
you can use to execute any SQL statement supported by your data
source.
Execute SQL statements from a field value
You can now use a SQL statement stored in a field to both import and
export ODBC data.
1 Use a calculation field to dynamically generate SQL statements for
each record.
1 Use a text field if you want to store a static SQL statement.
1 Use a global field to store or calculate a single static or dynamic
SQL statement that is executed for every record.
1 Use a non-global field to store a different static statement in each
record.
Import named ranges of Microsoft Excel data
The ability to import named ranges of Microsoft Excel data is
especially useful when you have:
1 more than one row of description
1 label data above the actual spreadsheet data that you want to import
1 a number of sets of tabular data on a single spreadsheet that can
begin at any cell location
Search only the relative path for FileMaker Pro files
When you open a file with the relative path option selected,
FileMaker Pro searches only the volume the parent file is on. Neither
the network nor any other volume is searched. When you open a file
on a host with the relative path option selected, FileMaker Pro
searches only the volume on that host. The local disk is not searched.
Select a
named range