AnsweredAssumed Answered

How to refresh SQL calc fields?

Question asked by openspace on Feb 23, 2015
Latest reply on Feb 23, 2015 by openspace

Hello, I have the following sql inside of a calculation field. The function works correctly, but it does not refresh the data when records are added or changed. For instance this field calculates how many active members there are. When I remove or add members the result does not update.

 

I've tried refreshing the field, but the only thing that seems to update it is to open the manage>database window. I'm running filemaker 13.

 

SQL = ExecuteSQL ("SELECT SUM (\"Member Count\") FROM Memberships WHERE \"StatusExpiry\" = 'Active' " ; "" ; "")] ;

Outcomes