ESS refresh problem / show all records not showing all records

Discussion created by mrwatson-gbs on Nov 17, 2011
Latest reply on Nov 22, 2011 by mrwatson-gbs

FM Pro: 11.0v3 Advanced

MAC OSX: Lion 10.7.1

ODBC Driver: Actual Technologies Open Source Databases driver (fully licenced)

DB-Type: MySQL


This is more of a warning than a request for help...


I've got an FM-DB and an online shop, connected via ESS-Technology.


After having done stuff happily between FM + ESS I then had to restore the MySQL DB from a backup.


It was only then, that I noticed that show all records / show omitted and some other commands (notably Go to related records), don't actually seem to send an SQL command to the MySQL DB.


FM was only showing the 3 records that it knew about, while in the MySQL DB there were thousands.


Only searching for a non-empty id in the id field really actually then loaded all the x-thousand records which were now in the MySQL Database.


Anybody got succinct information about which commands really force FM to query the remote DB?