Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Hi,
>>
>>We seem to be having a problem with seek not finding records.
>>
>>We perform the seek on a table with a that has an index on a char(13) field, and although the record exists, the seek command and the locate command are not finding them. I've even tried using Locate with the NOPTIMIZE clause, but this is also doesn't find the record. What is funny, is if I scatter the record, delete it ( and blank all values), then append a blank and gather into this, the seek command works.
>>
>>Is there a known bug? and what is the work around - apart from scatter and gather.
>>
>>Thanks
>>
>>Macer
>
>Sounds to me like you've got data corruption. Use a good tool like FoxFix or Stonefield to correct the problems then rebuild all your indexes.
Since, getting these problems all indexes are regualarly deleted and rebuilt - without much success unfortunately.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement