🚀 go-pugleaf

I have a grid that don't work properly.

On Form Open I do this :

form.query1.sql = "SELECT * FROM 'X.dbf'"
form.query1.active = true
form.grid1.datalink = form.query1.rowset

And the grid1 fill with the data

During the program I must change the query on the grid and I use this
instruction:

form.query1.sql = "SELECT * FROM 'Y.DBF'"

In the other GRID (grid2) that appear in my form, this instruction
change the grid but with this grid1  I must do:

form.query1.active = false
form.query1.sql = "SELECT * FROM 'Y.DBF'"
form.query1.active = true
form.grid1.datalink = form.query1.rowset

With this istruction grid1 is filled but when navigate throw the rowset
the data disappear.

On grid1 there are no events that can change the data; the rowset is
only read (requestlive = false)

There are someone that know the resolution of this problem ?

Pleas help me. Thank you for your attention