Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unatended index recreation
Message
De
10/08/2001 06:08:05
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00541136
Message ID:
00542182
Vues:
26
>>
>>When it's indbc() no problem. Problem when it's not. Thanks.
>>Cetin
>
>I was able to recreate the problem (Database invalid) by deleting the CDX file form the drive. When I issued INDEX ON something TAG something I got the Invalid datbase message. I was able to issue the INDEX ON something TAG something command successfully but it is a bit risky.
>
>I opened the DBC using USE something.DBC EXCL found the Index enries associated with the DBF and issued DELETE for delete them from the DBC. I then closed SOMETHING.DBC and issued the index command successfully.
>
>You can do what you want by hacking the DBC file, if you dare.
>
>Good Luck.

Ken,
Dared already and solved - not only for this but for some other things now I prefer to rewrite DBC behind the scenes :) I was looking for a simplier way.
Now what I do is to get a copy of DBC as a dbf, remove table, add table, get Property, Code, RIINfo, user fields back from copy for items I need.
Thanks.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform