Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with requery a view
Message
 
À
23/04/2004 11:20:31
Mike Sue-Ping
Cambridge, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00897614
Message ID:
00897730
Vues:
18
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
>>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform