Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Requery of a View on a Remote View
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00410960
Message ID:
00410984
Vues:
12
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform