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.

Wrong record count from ODBC source

eljefejb
in External Data Sources

Featured Replies

I have a few Oracle tables in my file, connected by ODBC DSN.  I have noticed that one table in particular is showing an incorrect record count.  When you first open the file or change to the layout in question, sometimes the count shows the correct 11,800 records.  However, when I do a find that I know should return 4600 records, I get only 230, and the total record count goes down to 8200.  Very weird.  Anyone seen this type of behavior before?

Which side is ODBC? I assume you are calling from FileMaker using ODBC to retrieve data from Oracle? Would that be your scenario?

  • Author

Correct.  I have a system DSN set up to connect to the Oracle DB, and I'm using that in FileMaker as the external data source.  The weird thing is that it seems to be limited to this particular table.  All the others work just fine . . . so far as I can tell.

Create an account or sign in to comment

https://fmforums.com/topic/93958-wrong-record-count-from-odbc-source/
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.