Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record is not in index (Error 20) Cause?
Message
 
À
29/01/2024 08:59:30
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01687574
Message ID:
01687596
Vues:
30
>>Dragan - Very interesting thought re: collate sequence. I need to wrap this up this morning but will do one more test run as is to test out that theory.
>
>Very simple to test - just add
>
... collate "machine"
>(must have quotes!) in the index command. See if it fixes it.

Thanks. What I did was record a LIST STATUS (which includes COLLATE SEQ) to text files before and after the REINDEX "fix" and compared them. Collate was MACHINE in all cases, but the index was no longer set as the MASTER index tag. I've added SET ORDER TO indexTag as part of the REINDEX "fix" and the problem no longer appears.

Would love to get to the bottom of this--maybe someday I will--but that day's not in my immediate future as I'm being bombarded with projects and this rabbit hole has already swallowed tons of hours.

Thanks again, Dragan and the rest. Very much appreciated!
________________
_____/ Regards,
____/ al

___________________________________________
www.jcn-associates.com
Visual FoxPro Database Application Development and IT Project Management
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform