Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindex a table without command reindex your sugg. pleas
Message
From
10/07/1996 14:00:28
 
 
To
10/07/1996 13:00:56
Francois Liboiron
National Bank of Canada
Montréal, Quebec, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00003699
Message ID:
00003700
Views:
30
>I Want to reindex my tables and I am using this commands
>and it does work : Open database dbc_name exclusive
> Delete filename.cdx && Delete my index
> && to not use REINDEX
> Use mytable Exclusive
> Index on key tag key
>
>I got a message: "Database is invalid, please validate", when I try to create a new index. If I run Validate database recover It says that my tag in the CDX was not found in the
>DBC. My boss don't want buy Database stonefield tool kit, so
>please HELP ME...

You don't have to delete the cdx, just to DELETE TAG ALL. I don't know if this will solve the problem but at least the cdx file will always stay on the disk.

There was a message this morning about the command VALIDATE DATABASE. You may want to retrieve this message to see if this will help.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform