4 Replies Latest reply on Feb 2, 2011 3:27 PM by jjbong

    ODBC update doesn't sync correctly with shadow table if done from trigger

    jjbong

      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.