Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing mystery ???
Message
 
À
10/02/1999 11:17:49
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00185510
Message ID:
00186513
Vues:
28
Nancy,
If you're still interested, here is code which will re-create this effect. Notice that it is divided into segments, each to be run on a different session of VFP (2 VFP's loaded at once, on the same machine, defaulted to same path) in a certain sequence.

*- Run this segment on Session #1:
CREATE TABLE tblIndex FREE (cDummy C(10))
APPE BLAN
REPLACE cDummy WITH "Hello"
USE

SET EXCL OFF
USE tblIndex && Table is opened SHARED.

*- Now run this segment on Session #2:
SET EXCL OFF
USE tblIndex && Table is now opened twice.

*- Now run this segment on Session #1:
INDEX ON cDummy TAG cDummy && Creates tag even though opened shared & in use.

*- Now run this segment on Session #2:
BROWSE && This demonstrates that the table is still useable.
USE
USE tblIndex && Here's where you finally get an error.


Have fun!
Mark


>Hi, Mark-
>I'd sure like to see your actual code that produces this effect. I'd like to create a Fox2 format file and try it out.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform