I got this strange behaviour in FMS16 where I use ESS for Views in MS SQL Server.
When I look at records form that view in MS SQL Server Management Studio I see 5 records.
but when I look at that ESS table in FMP I only see the last 4 records
Strange this is, that if I click on the left button that is Refresh Window with "Flush cached join result" and "Flush cached external data" both enabled, I for 0,5 seconds see 5 records on Total (Unsorted) records, but then it goes back to only 4. I never really see that 5th record appear in List view or Table View.
There are no field that are set to be mandatory that might cause this problem
The ODBC data source is a System DNS using 64-bit, same as FMS. Driver used is "ODBC Driver 13 for SQL Server".
I have not added any extra fields to the ESS table. Neither have I added any validation to any of the fields in the ESS table.
Why am I only seeing 4 records but can see 5 for 0,5 second after Refresh Window?