Skip 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.

Filemaker accessing SQL Table?

lizzie
in Script Workspace and Script Triggers

Featured Replies

Greetings

Is it possible to run a script in Filemaker which accesses a SQL table, runs a SQL query and posts that data back into Filemaker?

If so, how would one do this?

Our developer has left us and unbeknown to us, converted our Filemaker DB to SQL... our online orders are now housed in a SQL table and while I have learned how to run a SQL query, it would be much easier to execute the script from FM so as to draw the data back into the system that our company runs on...

Any help/advice would be greatly appreciated.

If you upgrade to FM9 you can read create edit and delete data from your SQL tables directly in FMP. Using External Sequel Sources (ESS)

  • 2 months later...
  • Author

Greetings

Am on FM 9 (must update my profile)...

Where do I get hold of ESS?

Will review in the meantime and see what I can come up with!

Mucho gracias!

http://www.filemaker.com/support/technologies/sql.html

Chapter 5 of the User's Guide should have some info.

Hi Elizabeth,

Am on FM 9 (must update my profile)...

Yes, please do. It really makes a difference in what we can suggest as answers to your questions.

TIA

Lee

You will need the odbc driver if you are on mac... http://www.actualtechnologies.com/

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

Account

Navigation

Search

Search

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.