At 08:54 AM 3/1/2005 -0500, Amanda Brown wrote:

>I'm using remote views to hit SQL server data from my VFP 7.0 app. Once

>I set the parameter, the remote view is retrieved just fine, but when

>the parameter changes and I requery the remote view, it doesn't refresh.

>It sticks with the old parameter.

>

>I've been able to rig it by closing the remote view and reopening

>everytime the parameter changes but that's a pain.

>

>Any ideas on why it's not refreshing?

Assuming there isn't a typo in the view parm (ie, vMyParm is set, but

vMyPorm is changed), the only thing I can think of off the top of my head

is that the view isn't in the current work area and you are issuing

requery with no parm:

like this:

* amazing code here

requery()

instead of this:

* amazing code here

Select MyView

Requery()

or this:

* amazing code here

Requery("MyView")

HTH.