AnsweredAssumed Answered

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

Question asked by jjbong on Jan 28, 2011
Latest reply on Feb 2, 2011 by 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.

Outcomes