Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VIEWS vs FILTER
Message
De
16/11/1998 15:22:36
Ian Matthews
Up & Running Technologies Inc
Chestermere, Alberta, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00157948
Message ID:
00157969
Vues:
17
>>3: I found that unless I set SEND SQL UPDATES on in the View Designer, that the updates did not get sent to the base table. I was using TABLEBUFFER = 3-OPTIMISTIC ROW BUFFERING, and TABLEUPDATE(.T.) in my SKIPx commands. I think the TABLEUPDATE only updated the TESTVIEW info with its related cursor info. Is there anything I am missing here or is SEND SQL UPDATES the only thing I need to know?
>
>If you have optimistic row buffering for the view and move through the view records you don't need TABLEUPDATE because when you move off the record it gets updated automatically

Thanks, I just figured that out 20 seconds ago. I wonder why this occurs in VIEWS and not in other TABLES.

Also, do you have any specs or anecdotel evidence on how much faster VIEW's are than the FILTER command? Edward indicates that he uses VIEWs for everything but I already have FILTERs set up so I am trying to decide if I should rewrite:
- all my parent/child stuff;
- just my parent/child grid stuff, or;
- the parent/child code for the grid the one grid I am having probs with.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform