Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Order in Views?
Message
De
30/04/2001 10:13:11
 
 
À
30/04/2001 09:25:04
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00501476
Message ID:
00501502
Vues:
23
This works for me, but it may not cover all your needs.

First issue a TABLEUPDATE() to make sure you've got no uncommitted records in the view, then
llResult=CURSORSETPROP("Buffering",3,"MyView")     && Row buffer
INDEX ON Whatever TAG MyTag ADDITIVE
INDEX ON SomeOtherField(s) TAG MyTag2 ADDITIVE
SET ORDER TO MyTag
llResult=CURSORSETPROP("Buffering",5,"DetailView") && Table buffer
>I have a need for the view in a grid to display in different orders depending on the search criteria that has been selected. I'm under the impression after reviewing past threads that there is not a way to do this through the project interface, but may be possible progmatically. I keep getting the message that I'm not allowed to create indexes on views for buffered tables. I've considered using multiple views (only the order being different) for the grid source, but that would ineffiecient for a number of reasons that I can see. What is the correct way to handle this? Thanks!
>
>Regards, Renoir
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform