Information générale
Catégorie:
Codage, syntaxe et commandes
Glad it helped.
By the way, for small tables and for critical applications you may use this to check for corrupted indexes. Let us say you have index on the character field name 'testcdx'. Then set filter to testcdx="" and select * from ... where testcdx="" should give different results if index is corrupted.
>I reindexed the table....that fixed the problem...thanks!
>
>>If it is "like", then you should see the difference, but if it is "=" , then results should be the same. In case you use "=" in both, do the results differ substantially, or it is one-two records? If there are a few records it may indicate that index file is corrupted.
>>
>>>This has to be a stupid question...but for the life of me I just don't get it.
>>>Anyone know why #1 would be giving me records that dont show up in #2 ???
>>>
>>>1.
>>>Select Table1
>>>Set Filter to Field1 = 'Myvalue '
>>>
>>>2.
>>>Select * From Table1 Where Field1 like 'Myvalue '
>>>
>>>I've tried using an '=' instead of the 'like'...still end up with same results...
>>>I made these examples look like what Im doing here (the spaces at the end and all)
>>>Made sure the records were not deleted or something lame like that...
>>>....driving me nuts..anyone gotta clue?
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