How can I prevent a FileMaker “fetch forward” error when transferring data to MySQL via an ODBC connection?
In general, this error means that FileMaker is no longer serving data through an ODBC connection. There are several problems which can cause this error, including: 1) FileMaker has crashed. If FileMaker 5.0, 5.5 or 6.0 [for Windows] is the source database, then the Fetch Chunk Size parameter in the ODBC FileMakerPro Drive Setup panel should be set to a maximum of 100. When working with more than 500 fields, this parameter should be set to 25 or even as low as 10. Setting this parameter too high will often cause FileMaker to crash during the data transfer which will usually result in a “fetch forward” error. This ODBC configuration parameter does not exist with the FileMaker 7 ODBC configuration. 2) FileMaker is too busy performing calculations to respond to requests for data through an ODBC connection. If FileMaker unstored calculation or summary fields exist within the database, then these calculations will have to complete before the first record is returned through an ODBC connectio
