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.

Failed to allocate statement

Tomi Saloniemi
in External Data Sources

Featured Replies

I'm having problem with inserting or updating data from FM 7 to MySQL via ODBC. Sometimes i get error message "failed to allocate statement". It's a bit frustrating if i'm inserting hundreds of rows and then figuring out which one was left out... Any ideas what is causing this?

I had the opposite problem...from MySQL to filemaker.

I found a check box on the Advanced tab for the ODBC driver setup.

"Allow big results"

I found by checking this, you can import more records.

I don't know if that helps but there it is.

  • 2 weeks later...
  • Author

Could the problem be that FM hasn't yet calculated all data needed for MySQL insert statement and thus giving error message could not allocate statement?

And if so, how can i make sure that the statement is made after it is ready?

Anyone have any ideas about this?

  • Author

anyone know what does the error code 1407 Failed to allocate statement (ODBC) mean? What causes it? Help please!

Create an account or sign in to comment

https://fmforums.com/topic/36848-failed-to-allocate-statement/
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.