Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing a View
Message
De
18/03/1999 14:23:32
 
 
À
18/03/1999 14:19:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00199394
Message ID:
00199396
Vues:
22
>Is it possible to index a view. I have crated a view, brought it into the report designer. I want to set a relation from a field from another table in the report that would drive a key field in the view. The view designer lets me set an order, but when I try to drag the relation line in the designer, I find there is no index in the view I created. I am new at this, so forgive me if this is really stupid.

You may index a view the same way as table:
Select MyView
=cursorsetprop("buffering",3) && if it's not 3 yet
Index On myfield Tag myfield
Now you may use SET RELATION
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform