Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to set
Message
 
To
26/06/2002 09:30:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00671823
Message ID:
00672442
Views:
8
>One "change" is that your application will be really fast if you use p-views in a grid (as compared to a filtered table in a grid).
>
>As to the changes you have to program - one thing that is different is that a view can have no permanent index. For instance, if a certain form has a statement like "SET ORDER TO ClientCode", you will have to change that. The view can already be ordered, but you can't SEEK - unless you create a temporary index after opening the view.
>
>Some other things may change, too. The framework I use needs to detect the primary key for some tasks (e.g., show audit trail). It can't get the primary key for a view (of course not; a view has no permanent indices, and therefore no primary key).
>
>You will have to do some adaptations for views.
>
>But in general, I believe these changes will be much simpler than doing the updates yourself, through a cursor (your cursor doesn't have permanent indices nor a primary key either, nor does it initially allow SEEK, right?).
>
>But in many cases, the view or p-view can be treated as just another table.
>
>Hilmar.

That's not a problem since, as you said, cursors doesn't do this neither and I've been able to find my way. I think the next step would be to start experimenting and make some conclusions. I've started reading the VFP programmer's manual to expand some concepts before "put my hands on the fire" <g> but if you can point me to some online resources on the matter it will be greatly appreciated.


Thanks again,

Enmanuel
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform