Quick ExecuteSQL questions: global fields and refresh
I have the following calculation field set as a global field in a solution:
ExecuteSQL ( "
SELECT \"Content Vocabulary_Academic Language\", COUNT ( * )
FROM \"eval form\"
WHERE Phase = \"_g_Phase__gxt\"
GROUP BY \"Content Vocabulary_Academic Language\"
" ; " " ; ""
The problem is, it works fine as a non-global field but fails ("?") when I set it to global storage. (I want the results to be seen in all records.) What do I need to do to make it work?
Also, the results don't update when I use the Refresh Window script step (on record load, layout load, and manually fired)--it only refreshes when I perform a Find. What do I need to tweak to get that to work, too?
Thanks in advance for for your help!