I have a query that is not running like it should. Within this query, under 'Actions', I have checked the box that says "Execute a script for each record". The scripting that pertains to this is only two lines long - the first line clears the current value from a field and the second line recalculates this field value. When I go to 'Test Query' it works perfectly. I have a variable set up in my main scripting (records from query). When I added some additional data to the program and ran the main code, it appears that the query is not actually running (this assumption is based on the fact that none of the records have been recalculated). Why is the query not running?
I did go back and add a third line of code to the query scripting - to 'Refresh' the newly updated field but nothing changes so I am not sure that the query is even running.
Tubbritt instructed me earlier on how to debug the queries but now I cannot even find the query in the 'Script Designer' - I can easily access them through the 'Query Editor' though... where did they go to?