Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SDT blew away my indexes on a table..
Message
De
03/04/2002 10:12:20
 
 
À
02/04/2002 12:45:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00640000
Message ID:
00640345
Vues:
22
Hi Sandi.

>I went into my DBC and made a flag change (Reportable = .T.) and when I tried to save I got a strange error. (something about an index problem. There was no problem yesterday and nothing had changed).

A simple change of a property like that shouldn't have anything to do with indexes. What error message did you get?

>The next time I went in all my indexes on that table are gone. How do I recover them without retyping them all in.

Check the meta data (specifically COREMETA) to see if the index definitions still exist -- look for records with CRECTYPE = "I" and COBJECTNAM = name of table + "." + name of tag. If so, then instantiate DBCXMgr and call SDT's Reindex method, passing .T. for the 3rd parameter, which tells it to recreate the indexes from the meta data alone. If there aren't any records (try with SET DELETED OFF and recall any deleted ones you find), then you'll have to recreate them manually.

Doug
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform