Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View won't requery
Message
De
08/12/2009 09:36:15
Michael Gass
Instructional Software, Inc.
Kirkland, Washington, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01438038
Message ID:
01438047
Vues:
41
>>I have a parameterized view that uses a public variable. When I use REQUERY() from within my program the view doesn’t update. If I stop the program just before the requery and use =REQUERY() from the command window, it requires correctly. Does anyone know what I might be doing wrong?
>
>Is the view based on another view? Any other details about it?

Thanks for such a quick response Sergey. The view has three tables. The first two are connected with an Inner Join with the primary key in the first table. The second and third tables are connected with a Left out Join. The parameter is public variable. Let me know if you need more.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform