Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Phantom Record
Message
From
17/04/2002 15:37:51
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
17/04/2002 15:34:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00646046
Message ID:
00646049
Views:
13
>I have a table that when I use the find menu command I can't a particular record(Not Found). However, If I use the Seek() Order myIndex it says the record exists. How can this be fixed.

Two possibilities come to mind:

  • Index corruption. Do a REINDEX.
  • Some difference in the environment between both commands, like SET DELETED or SET FILTER. Use the debugger to check. If you use a form, remember that forms with private datasessions don't necessarily "respect" your default settings for SET DELETED and others.

    HTH, Hilmar.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform