Query doesn't refresh if subquery value change

Query doesn't refresh if subquery value change

Hi Zoho People,
I run through a simple problem of a query not being refreshed.
I have a table called "Params" with a column "Mois". The table has a unique row with the value of say "8".

I have written this Query statement :
SELECT "Date", "Qui", "Jour" , count(1) 'Nb Vis' FROM "Visites" where month("Date") = (select "Mois" from "Params") group by "Jour", "Qui"

This statement runs without problems and reports all rows whose date is the 8th month.

If I update the table "Params", changing the value from 8 to 9 for example, the other query should retrieve all rows whose date is the 9th month. But it does not ! It keeps getting the value 8 from "Params" table. I didn't find the trick to make it refresh without editing the query and saving it again. How to make it dynamic ?

Cheers,