Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing a table while a table is shared
Message
 
À
05/03/1999 09:54:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00194459
Message ID:
00194462
Vues:
27
David,
You can do INDEX ON expr TAG tag OF MyIndex.Idx
This creates a non-structural index. I recently found out that if you have a file with no structural .CDX file opened shared, that one user can create a structural tag (even though it's currently in use). However, when someone else attempts to open the table, they get an error because it now wants to open the CDX file as well (which is opened exclusively, because it was just created).
Watch out for that!
Mark

Actually, the preferred way of getting sorted data in a shared environment is to SELECT...ORDER BY... into a cursor.

HTH!
Mark

>Is a way to index a table while i have the table shared open
>
>thanks,
>
>dave
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform