Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing trouble
Message
De
05/03/2002 11:49:34
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
05/03/2002 11:27:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00628470
Message ID:
00628503
Vues:
22
This message has been marked as a message which has helped to the initial question of the thread.
>Can it be done without creating a view?

You can create an index but it should not be added to the structural cdx. If you do that, you will get an error whenever you open one of the tables without the other one.

If you can live with creating this index when the form launches etc. then you would (in pseudofox)

select employees
set a relation from incidents to employees.
index on employees.emp_name to caution.idx compact

I couldn't live with such a performance hit, so I'd use a view or SPT and index the resulting cursor by employee name.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform