A parameterized view as a grid recordsource 1

[trimtrom]

Hello,

I am a beginner Foxpro 6 programmer, and I have a problem with parameterized views.

I am trying to use a view as the recordsource for a grid (on a pageframe). By changing the parameter of the view, I want to change the data in the grid, and I have written the following code in the click event of the page frame.

local paraid
paraid = thisform.pfdbtr.page1.txtid.value
thisform.pfdbtr.page2.grid1.recordsource = ""
thisform.pfdbtr.page2.grid1.recordsource = "vwslaccount"
thisform.refresh
thisform.pfdbtr.page2.grid1.refresh()

By changing the parameter paraid, I hope to change the data of the view in the grid.

However , in practice the view shows an input box to get the first parameter when the form opens, and thereafter refuses to refresh and change the data at all, although paraid has changed. Help!!

Code snippets appreciated.

Thanks,Trimtrom

 

[Nifrabar]

Hi Trimtrom,
Did you try to requery after changing your parameter ?
=requery("vwslaccount")
This should be done every time you are changing your paremeter of the parametrized view.
I would suggest to requery in the valid method of thisform.pfdbtr.page1.txtid

However , in practice the view shows an input box to get the first parameter when the form opens, and thereafter refuses to refresh and change the data at all, although paraid has changed.
Try to open the view with nodataonload. Than somewhere in the initmethod of the form :
paraid = thisform.pfdbtr.page1.txtid.value
thisform.pfdbtr.page2.grid1.recordsource = "vwslaccount"
thisform.refresh

-Bart

 

[trimtrom]

Thanks - it was the requery command that I needed. All is now working.

Trimtrom