Filemaker accessing SQL Table?

[lizzie]

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.

[Ocean West]

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)

[lizzie]

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!

[mr_vodka]

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

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

[Lee Smith]

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

[Ocean West]

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