Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with requery a view
Message
 
To
23/04/2004 11:20:31
Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00897614
Message ID:
00897730
Views:
19
In the view designer, there's a SQL button on the toolbar that shows what the query for the view looks like. Please post that code, along with a description of the results you're getting and how that differs from what you're expecting.

>Fabio,
>
>Thanks for replying.
>
>By "composed" I mean that vuall contains only fields from the three other views. It is a local view too.
>
>I do issue requery() on all three views prior to requery("vuall"). Vuall does not show the same number of records as the other three.
>
>Mike
>
>
>>I created another view (vuall) that is composed of some of the fields from all three previous views.
>>
>>composed ? In which way?
>>
>>If vuall is local, then for REQUERY("vuall")
>>
>>REQUERY("vu1")
>>REQUERY("vu2")
>>REQUERY("vu3")
>>REQUERY("vuall")
>>
>>
>>se vuall is remote union rewrite with the UNION,
>>
>>...
>>UNION ALL
>>...
>>UNION ALL
>>
Previous
Reply
Map
View

Click here to load this message in the networking platform