Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>A corrupt index may be at fault here. Try a REINDEX, or, if your table isn't intricately linked in a database, you could manually delete all your index tags, then recreate them.
>
>The table is not indexed but you appear to be right -- the index was corrupt and the table needed to be reindexed.
>
>Regards.
A table does not need to have an order set for LOCATE to use it, just that there be an expression matching the index.
Glad you found the solution. I agree with many others elsewhere that SCAN is much neater to code, and encourage you to make it your friend.
Précédent
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