Strange issue with Filemaker chopping off MySQL data values while using External SQL sources..??
Posted on 2010-08-23
I've got a Filemaker database connected to MySQL using ESS. I've got a basic layout in FileMaker that simply displays the MySQL data and allows me to edit it accordingly. For some reason, though, any values I place in text fields from within this FM layout get chopped down to the first character that I placed.
The MySQL database is using varchar field types with 250 char maxes. Updating records directly in MySQL works just fine.
In FM, again, it's trimming all of the text fields to a single character. the number fields are just fine. I've never had this problem and I've used ESS quite a bit so I'm completely stumped.
Any information on this would be greatly appreciated. thanks!