Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index problem
Message
From
25/01/2010 10:44:00
Nicholas Mason
London, United Kingdom
 
 
To
25/01/2010 10:32:06
Fabio Lunardon
Lunacom
Marostica, Italy
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Index problem
Miscellaneous
Thread ID:
01445756
Message ID:
01445804
Views:
35
>>>Your index doesn't happen to:
>>>
  • Be a unique index? Those should never be used, as far as I know.
    >>>
  • Include a filter? That might exclude the records you are missing.
    >>>
    >>>>Just to test I did rebuild the keys on that file, it still only left me with a few of the keys in the index. The rest where still missing.
    >>
    >>Thnaks Hilmar but I think I haven't explained what happened very clearly.
    >>
    >>The index file contained many different index tags on many fields and combinations of fields. The problem was that suddenly most of those tags disappeared. But there was no indication of any corruption, it was as though the tags had been deleted.
    >
    >set a breakpoint when TAGCOUNT("alias") change.

    Thanks Fabio but Its not a reproducible error and the file is accessed by many different jobs.
    I think it has happened before on this file some time ago
    • Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform