anomalies in simple ESS


Mac OS 10.4.11, FM9.0v Adv, MySQL server, Navicat 7.0.7, Actual Technologies driver

Have an implementation on a server that is excrutiatingly slow, processing ESS data (using looping scripted ESS to FM dtata parsing), so built a local database to test simple importing from ESS into FM as an alternative. The following is issues with my local testing.


created a new FileMaker database, added ODBC source
Imported 3700 records (text fields) from a FileMaker db, into ESS layout in FM. no errors. Deleted records, FM indicates zero records in rolodex, the records still exist in the Navicat db, explored variations on refresh and flush SQL, highly suspect results; something to do with FM's quirky way of handling ESS it may seem.


So to test a simpler scenario, manually deleted all records from within Navicat, created a new FM db, add same ESS (navicat), imported 63 records.

41 records display in ESS table in FM layout in form view; there are 63 records in the actual ESS Navicat table. Show all only shows 41 total records.

switching to table view in FM ESS layout, there are then total 3 records TOTAL
switching back to form view, now there are 3 records TOTAL

sync the shadow table; there are now 41 records again


recognising that I am using FM 9 v1, and there is a v2 (383MB) updater yet to be downloaded, is this a known issue in v1?

.