Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SDT blew away my indexes on a table..
Message
From
03/04/2002 10:12:20
 
 
To
02/04/2002 12:45:36
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00640000
Message ID:
00640345
Views:
21
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
Previous
Reply
Map
View

Click here to load this message in the networking platform