Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to index results of query
Message
De
25/02/1998 10:16:12
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00079892
Message ID:
00081074
Vues:
43
>ys(3), and _work is usually "C:\scratch\". By using a separate .cdx file, we do >n't try to create a structural index, and it doesn't have to touch the 29th ( or >was it 28th) byte of the table header. > >Dragan, this still indexes the original file, which means it has to be used E xc >lusive. By using it as a cursor with NOFILTER (or, in VFP3 with an additional f >ield) means it's already used Excl. and is on your hard disk - much easier to i >ndex. This works for both read-only cursors and shared tables: indexing into anything else except .cdx-with-the-same-name-as-table doesn't touch the table at all. I've just opened a table in two instances of VFP, indexed it to two different .cdx files - the only trick was to Open Data Whatever SHARED. I really don't know where it defaulted to exclusive in my case (will have to check my config.fpw), but as soon as I opened both the database and the table shared, it indexed anyway you like - just as long as I've added a "to [filename]" clause. And guess what - LUpdated() consistently returned Jan 19th - which means it didn't touch the table at all, just read it and built an independent index file. Just try it.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform