Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Limit To Returned Records Via ESS?

Teutonic_Night
in External Data Sources

Featured Replies

I have a solution that needs to update records in a MySQL database based on actions in the local FM database. I have the ESS connection set up, can see all the fields I need, etc. The problem seems to be that I can only retrieve 255 records at a time from the MySQL database. I'm using the MySQL ODBC drivers from MySQL on a Windows 2003 Server running FileMaker Server 9 Advanced. FileMaker knows how many records are in the MySQL table (~25k), but seems to only be able to access 255 at a time.

I haven't been able to find anything on FileMaker's site about such a limitation, so I'm wondering if it has something to do with the MySQL ODBC driver or perhaps the configuration of MySQL. Anyone have any suggestions or run into similar issues?

  • 3 weeks later...

This shouldnt be be the case. You should be able to view all the ESS records. Is this in its own dedicated layout?

Create an account or sign in to comment

https://fmforums.com/topic/65343-limit-to-returned-records-via-ess/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.