VFP DBF Indexing

[Renebear]

I have built several VFP DBF with SSN as Prime Key. I have a mainmenu option to index all tables: example INDEX ON SSN TAG SSNKEY. After its execution, all the defined Prime Keys were switched to Regular Keys. What would be the best approach to reindex all keys without losing its original definition?

 

[danceman]

have you tried using the key word CANDIDATE.

If this does not work then use the command alter table to change the index to primary Attitude is Everything

 

[ramani]

Hi

Are you creating the index first time?. I dont think so. WHy dont you use REINDEX as your command.. instead of INDEX ON ...

ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com