Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relations, Filters and Views...oh My!
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00290353
Message ID:
00290412
Views:
14
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform