Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to set
Message
 
À
26/06/2002 09:30:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00671823
Message ID:
00672442
Vues:
7
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform