FM9 MyODBC

[firefly777]

So, I've got MyODBC 3.51 installed and set up, in OS X Leopard, as my system DSN, and it's working.

I can open up FileMaker 9 and connect to the external data source.

I can then open up the "Relationships" area in FileMaker, and create a local "table", linking to the fields in my remote MySQL table. Fantastic.

Now I can see remote MySQL records, viewed directly through a FileMaker layout. I've wanted this for YEARS!

My problem is, if I attempt to alter one of these records, FileMaker blanks out the field, and the field's data is cleared out in MySQL.

Oddly, this doesn't happen in int (numeric) fields - I can edit those just fine. Only in varchar (text) fields.

Can anyone offer me any clues? If FileMaker 9 has the capability to become an ODBC frontend, I would like the ability to edit my remote records!

Thanks in advance!