Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with GenDBCX
Message
From
28/12/1999 14:47:11
 
 
To
28/12/1999 14:08:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00309332
Message ID:
00309395
Views:
30
>Claudio-
>
>
>>I have been looking for some routine to reconstruct indexes, and founded Steve Arnott's GenDBCX. Reading his documentation, I guess that is a great utility, and I'm trying to use it, but I'm having some problems.
>>
>>What I did? I've deleted some CDX files (to simulate a lost of it), and executed the method CreateIndices, for the program recreate my indexes. No way: it shows me some errors message, such 'Primary Key already exists', 'CDX structure not find', etc...

>
>I may misunderstand you, but if you are simply executing the generated PRG then you are doing too much if all you want is to recreate the indices. The PRG that gendbcx (or gendbc, for that matter) will recreate your entire database. Instead, look at the prg and pullout the sections you need.

Nancy- genDBCX creates separate methods for recreating indeces, so there is really nothing to pull out.

Claudio- you are getting this error because you did not destroy the indexes correctly- you need to issue DELETE TAG ALL on the table, to let the table know that you are killing all the tags. Otherwise, the dbf itself thinks it is still tied to an index file.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform