>Scenerio: I have a Fox view that calls a remote Fox view. The first time I set the filter parameter and Use the view, it seems ok. Once I try to change the value of the filter parameter and do a Requery(), the parameter doesn't seem to get to the remote view behind the normal view and change what it has in the buffer. I've tried closing and reopening the first view, but the remote view stays open and seems to continue to not receive the new filter parameters. The program doesn't (and shouldn't) know of the existence of the remote view.
You could close the remote view generically by getting the Tables setting for the local view and USE IN the remote view, rough example -
OPEN DATA mydata
CREATE SQL VIEW rvRemote REMOTE CONNECT vfpconnection AS ;
SELECT * FROM names WHERE cfirst = ?vpcMyName
CREATE SQL VIEW lvMyLocalView AS ;
SELECT * FROM mydata!rvRemote
vpcMyName = "Bob"
USE lvMyLocalRemote
lcRemote = DBGETPROP("lvMyLocalRemote","View","Tables")
USE IN (lcRemote)
vpcMyName = "Harry"
REQUERY("lvMyLocalRemote")
Insanity: Doing the same thing over and over and expecting different results.