Jump to content

mySQL & fmpro 6 - how do i share mySQL db?


maureen567
 Share

This topic is 5643 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

anyone out there know and have used filemakerpro with a mySQL database?

not just a query, but actually sharing the database, so that if i edit on fmpro, updates the SQL db and vice versa.

can this be done with this version of fmpro 6?

if so, can you explain how to do this? (not just import export but dynamically sharing the dbase)

Link to comment
Share on other sites

There's no magic, just a lot of hard work to make this happen. You'll need to code your FM database so that whenever something happens in it (new data, data deleted, changed data) it triggers an ODBC/JDBC action to the mySQL db. And vice versa.

Since FM doesn't support events you'll have to use an events plugin or otherwise code this in your scripted workflow. For best results I would suggest you also use the PDM SQL plugin instead of using FM's functionality.

To update FM from mySQL it depends on what front-end you're using but it's the same principle.

Most of the work will be in deciding what to do with data that is changed both in FM and mySQL: which one is the master? What change do you keep and which one do you overwrite?

Link to comment
Share on other sites

This topic is 5643 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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