Thanks for the reply!

It was all views but we figured it out. I was setting the parameter to

fieldname in the view but the application was referencing it as

m.fieldname. Once I changed the view parameters to m.fieldname, they all

worked. Can't say I entirely undertstand the m. problem but it did solve

it.

Thanks!!

>>> tedroche@tedroche.com 3/1/2005 10:26:09 AM >>>

On Mar 1, 2005, at 8:54 AM, Amanda Brown wrote:

> Hello all!

>

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

Is this occurring on only one remote view out of many? Try to create

another view and see if you see the same problem. Perhaps there's a

simple error like a mis-named parameter or a fieldname the same as the

variable name (the fieldname would take precedence). Can you post some

simple code that shows this problem?

If that doesn't isolate the problem, most likely, there is a setting

altered from the default that is causing your new request not to be

seen by the server. This is usually defined at the connection level and

not for an individual view. Can you run GenDBC (located in

home()+"\tools\gendbc" and post the code that defines the connection

and the remote view and sets all of their properties?

Ted Roche

Ted Roche & Associates, LLC

http://www.tedroche.com

[excessive quoting removed by server]