Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery of a View on a Remote View
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00410960
Message ID:
00410984
Views:
13
>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
** lvMyLocalRemote and rvMyRemote are now open
lcRemote = DBGETPROP("lvMyLocalRemote","View","Tables")
** this is assuming that there is only one table in the Tables list
** if there is more than one you'll have to parse out each one
USE IN (lcRemote)
vpcMyName = "Harry"
REQUERY("lvMyLocalRemote")
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform