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.

Accessing FM7 odbc data source From within FM7

silver_surfer
in External Data Sources

Featured Replies

Hi

How can I get a FM7 client data source to appear as a DNS source within FM7 execute sql script step on a mac. I've tested the odbc connection outside FM7 using odbctest and it works fine. I don't seem to have a problem with it on a pc. I've tried removing the DataDirect sql client as stated on the FM site but that just left me with no odbc support within FM at all.

Thanks

Why would you use ODBC to transfer data from a FM file to another FM file? You can import/export or use Set Fields.

That being said, there are reports of people making this work on Windows but not on Mac. There could a hard-coded block preventing this.

  • Author

Basically I want to be able to build dynamic queries on the fly, that can be used to build reports. I could do the same thing with calculations but an sql string seems like a very simple and flexable way to do it.

What you may want to test for, is if errors get passed back to FM when you

generate your reports...

I tried an UPDATE sql statement only to find out that if there is no match

and therefore no update is done...no error is sent back to FM!!

So you may end up creating an empty report on the fly!!

Dan

Create an account or sign in to comment

https://fmforums.com/topic/33598-accessing-fm7-odbc-data-source-from-within-fm7/
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.