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?

Re: anomalies in simple ESS

Chris Brown wrote:
>
> 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?
>


update: partially corrected with ActualTechnologies v2.8b driver
show all still doesn't, but doing a find will return 3 records (usually,
sometimes 6) - a product of the demo version...

Total records is still 0 in FM ESS table layout, and the Navicat db has
to be manually refreshed, using FM flush SQL does not alter the record
count in the Navicat table