How is your view parameter referenced in your remote view? It should be

preceded by a ?. Something like this:

SELECT fields FROM table WHERE pkey = ( ?m.pkey )

If it isn't, then the parameter only gets evaluated the first time the

view is executed.

> 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?

>

>

--

Richard Kaye

RFC Systems

Voice: 973.761.0868

Fax: 973.761.4329

For the fastest response time, please send your tech support

queries to techsupport@rfcsystems.com

---------------------------------------------------------

---------------------------------------------------------