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

April 5, 200619 yr

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)

April 10, 200619 yr

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?