Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing mystery ???
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Indexing mystery ???
Divers
Thread ID:
00185510
Message ID:
00185510
Vues:
66
Heelo, All!
Can someone please explain these results:

1) Open two VFP 5.0 sessions on the same machine.
2) SET EXCLUSIVE OFF, on both.
3) USE MyTable (any FREE table), in both sessions (same table used).
4) In one session, do an INDEX ON Expr TAG Expr - no problem.
5) In the other session, table is still modifiable. Try SET ORDER TO Expr - error: 'Table has no index order set'. Close this table with USE and try to re-open - error: 'File access denied'.

It's like the table went from SHARED TO EXCLUSIVE use in the first session, because of the INDEX command!

All ideas will be appreciated!
TIA
Mark
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform