Title
ODBC update doesn't sync correctly with shadow table if done from trigger
Post
Using FileMaker Pro 11 with MySQL.
I set up a trigger on data modify (the modified data was in a shadow table). The triggered script did an update to a different MySQL table using ODBC, but the shadow table in FileMaker didn't reflect the updated data (it was all added data, not updates to existing rows - it just didn't see the new rows). I verified that the new rows were there in MySQL.
I changed the interface to run the same script from a button on the window, not from a trigger, and it worked fine.
Not a problem for me at this point, as I've reworked the interface so it works. But I thought I'd post the problem.
Interesting...what if you added a Refresh Window to the triggered script?