Hey Everyone,

I have been using FM to access a mysql database.

I am able to connect and view data perfectly, add/delete records.

However, I am having a serious problem updating external records.

When I change a field's data and commit the record, the entire data gets chopped after the first character.

A field that gets "abc123" typed into it and then committed, results in "a".

Has anyone had this same problem??

It is driving me crazy.

Thanks

You will need to describe what platform you are on and what driver and driver version you are using.

Bruce,

thanks for the response. i am on a mac osX latest update (10.4.10).

I am using the odbc administrator and the latest mysql odbc driver.

FileMaker very clearly states that the only driver supported for this purpose (MySQL/OSX) is the one from Actual Technologies.

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

Edited October 8, 200718 yr by Guest