fmSQL Synch specifications

Desktop Enhancements: Alarms & Clock Software; Clipboard Software; Cursors; Desktop Customization; Gadgets & Widgets; Icon Tools; Icons; Launchers; Tweaks Software; Virtual Desktop Managers

Features specific to FileMaker v7 compatibility

account name and password options
layout name option, custom names for 'update' & 'select' layout (needed for multiple table support)
field names options, custom names for primary_key, last_mod & last_synch fields

General Improvements

streamlined interface, much easier to manage and edit configurations
last_synch timestamp now saved for each record rather than each table, better accuracy in finding modified data (records don't have to be processed twice for borderline cases)
improved support for MS SQL databases
change FM field setup from repeating field to portal, allows virtually unlimited number of fields for each configuration
configuration groups, synching configs can be grouped together and run at different times
multiple SQL/JDBC configurations, each synching config can use a different SQL database or connection
debugging tools, help find cause of invalid data errors due to type mismatch or validation restrictions on 'update' layouts
configurable sort order for configs during synch run
minor changes to Demo files to support new feature for v2
option to specify field separator (eg. pipe "|") used by SQL Plugin for select queries
added config for minimum seconds between last_synch and last_mod (defaults to 1 second)
date format now uses 'system settings' rather than asking which to use when different
improvements to error handling; synching process should be more robust
partial support for running via FileMaker Server
updated documentation pages (documentation for v2 still incomplete)

Bug Fixes

Operating systems Mac OS X 10.3, Mac OS X 10.4 PPC, Mac OS X 10.3.9, Mac OS X 10.0, Mac OS X 10.1, Mac OS X 10.2
Additional requirements SQL Plugin (demo included with fmSQL Synch)
JDBC driver for your database
FileMaker 7.x or higher