FileMaker Pro Advanced Updater 8.0v2

To meet the needs of the growing number of professional developers and advanced database creators, FileMaker Pro 8 Advanced includes all the features of FileMaker Pro 8, plus breakthrough development and customization tools. With the ability to customize menus and add custom Tooltips, as well as robust troubleshooting and database analysis tools, developers and advanced FileMaker users alike can efficiently build more powerful, more customized databases.
Enhancements:
- Scripts
- Using a script, you can no longer inadvertently set repetition 0.
- On Windows, fixed a problem that could cause FileMaker Pro to quit if a script attached to a field formatted as a pop-up menu was executed.
- Setting a repetition (greater than the first repetition) of a field through a script to an aggregated value of a related field now works.
- On Windows, the Send DDE Execute Script will now execute more than 127 times.
- Scripts that navigate to fields (for example “Go to Next Field”) can now enter fields that have “Allow field to be entered” disabled in Field Behavior options.
- Calculations
- Fields that have auto-entered calculations depending on other fields no longer rely on field order creation for consistent results.
- On Windows, Filter() and FilterValues() are fixed to be able to filter numbers to digits only.
- The default file option for data entry has been changed from “Ask whenever settings are different” to “Always use current system settings”.
- On Windows, the Print script now applies scaling options set for the Print Setup script that was executed previously within the script.
- On Mac OS X, fonts that have Postscript outlines instead of TrueType outlines no longer appear as out of range squares or invisible when saved to a PDF file.
- Import Records scripts that specify matching names for the “Arrange by” option now include fields that have been added or renamed in the import order.
- Field focus is now retained for the last active field after an unsuccessful find is performed.
- You can now tab to a field that belongs to a table further away than the current portal context and has no related record.
- Summary values based on fraction of totals sorted by a field now return correct results.
- Fixed a problem that could cause FileMaker Pro to quit when pasting into a text field formatted as a pop-up menu, checkbox or radio button.
- In a 24-hour time format, searching for time values less than 1:00 PM in a time or timestamp field no longer appends “AM” to search criteria, and 12 now searches for 12 PM instead of 12 AM.
- ODBC/JDBC (FileMaker Server Advanced only)
- Fixed a problem that caused java.sql.PreparedStatement.setNull to return incorrect results when used with timestamp and date fields.
- Fixed a problem that could cause FileMaker Server to crash when inserting a long string containing Japanese characters using java.sql.Prepared.Statement.
- Fixed a problem that caused ExecuteQuery () to fail when called multiple times on the same PreparedStatement object.
- Fixed a problem that caused a SELECT query to return invalid results when using table aliases.
- Fixed a problem that caused DataBaseMetaData.getColumnTypeName() to return Varchar on container fields. It now returns SQL_LONGVARBINARY.
- Fixed a problem that caused SQLDescribeCol() to return inconsistent results when container fields were empty or held data.
- When the Instant Web Publishing status area Language is set to Swedish, weeks that appear in drop-down Calendars will now start on Mondays instead of Sundays.
- New in FileMaker Pro Advanced 8.0v2
- Menu items that use scripts or script steps now function correctly in submenus that are more than one level deep.
- Tooltips
- On Mac OS X, custom tooltips now display in the correct location in Kiosk mode for all objects.
- On Mac OS X, tooltip contents now update correctly when users move from one object to another. In previous versions, tooltips did not always update correctly if they were exactly the same size.