Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unatended index recreation
Message
From
10/08/2001 06:08:05
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00541136
Message ID:
00542182
Views:
40
>>
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform