Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relations, Filters and Views...oh My!
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00290353
Message ID:
00290412
Vues:
16
>We have been writing in VFP for about 6 months now and are converting our existing business application from a dos dbms to VFP. We have not been using views yet. We have been running across situations where we have struggled with whether or not to use filters or setting up relations. Now we are wondering if we should be using Views.
>
>Right now we are using optimistic table buffering on our tables with relations or filters so that we can use =tablerevert across the board. Can we simulate this with Views?
>
>Are there any speed considerations we need to be aware of?
>
>Basically we feel pretty comfortable with the VFP syntax but we feel very ignorant regarding the best way to handle data in forms (ie relations, filters or views).
>
>Any direction or guidance would be greatly appreciated.
>
>Thanks,
>Paul Acton

View is optimistic buffer itself for the table(s) you use to create it, so buffering issue should not concern you. Generally, view will be faster, actually much faster than filters as soon as you try to use them in grids. There is known problem about views, it boils down to DELETED() tag issue, but it should be considered only if you work with large tables. Relations (i mean temp relations built by SET RELATION command) are question of personal preferences.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform