How to refresh MySQL structure

[AnFrusch@pepp]

Hello all, I'm trying to use FM10 as front end for a MySQL database.

I added 3 tables using PhpMyAdmin and configured DSN on Windows Server (at the moment i'm using FMS9 but I will install FMS10 soon).

I opened a filemaker database and edit External data sources, create new data source ODBC using the DSN of my server.

I opened database management relationship pannel and instance one of the 3 tables of MySQL db. I wrote a script which synchronize the SQL db with data of filemaker and save it. Once I finished to write the script I discovered that I have forgotten a field in MySQL so I added it through PhpMyAdmin.

I go back to filemaker and the last filed weren't in my table instance.

The only way to refresh the structure of the table seems to be remove not only the instance itself but the entire ESS. By removing the instance I've lost all the reference in the sync script (the string '

Thank you for reply..

[Jonathan Monroe]

> is there any way to update and refresh MySQL structure in table reference w/out this loss of time?

Select File->Manage->Database, press the Fields tab, select the MySQL table from the drop-down list, and press the Sync... button.

That should add any new fields to the TO that have been added to the MySQL table.

Jonathan Monroe

Actual Technologies - ODBC for Mac OS X

http://www.actualtechnologies.com

[mr_vodka]

http://www.filemaker.com/help/html/odbc_ess.20.8.html

[AnFrusch@pepp]

Thank you very much! I didn't notice the Sync option!

Very useful, thanks!