Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View won't requery
Message
From
08/12/2009 09:36:15
Michael Gass
Instructional Software, Inc.
Kirkland, Washington, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01438038
Message ID:
01438047
Views:
42
>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform