Find & Filter search results included partial-word matches when "Whole Word only" was specified
Find & Filter search settings = <Entire File/Show in Live Search/Selected Column/Exact String/Whole Word only>
Search = LED
Search results included = pulLED, faiLED (etc)
Changing search to "LED" still included spurious results (though maybe not as many).
Wayne
Win 10 120Pre21
Bug reports
Comments
Hi Wayne, I was not able to…
Hi Wayne,
I was not able to reproduce the issue. If you can reproduce it in a sample app, I'll gladly look at it
Was hoping it would clear up…
Was hoping it would clear up with updates but it's still not working for me. Searching for "Proj" returns "Projects" even though whole word option is selected.
What do I need to upload? I don't know what you mean by "sample app". Do you mean a sample file with a search set up showing the problem?
Wayne
Win 10, 120, Pre24
Wayne
Yes, a sample file !
Yes, a sample file !
Naturally, it works fine in…
Naturally, it works fine in the sample file.
My system is really messed up right now with many cases of buffering, locking up, and other misbehaviors. I tried repairing the database but it ran for 40 minutes with no resolution and I had to kill the process. Tried again later and this time it ran for an hour without completion.
File is appx 180,000 items and 95 mb.
Wayne
It could be a problematic…
It could be a problematic grid that locks up the repair process, I've seen this before, what you can do is mask the content (Tools > Database > Repair > More > Mask), compact and zip. Send it to me
(of course, do this on a copy of the file)
Pierre_Admin
Sorry, but there's no way I…
Thanks for the offer, but I don't think I'd feel comfortable sending personal info, even if masked. Are there any other options?
Would creating new grids and deleting the old ones do any good?
Another option is to delete…
Another option is to delete all items from a copy and try a repair. If it fails, send the file over
OK, I'll do that, though I…
I don't understand. You're going to repair an empty file? Then what? Am I going to copy items from the bad file to the empty repaired file?
I'll proceed with the deletions but I don't get it.
Indeed, the purpose is to…
Indeed, the purpose is to find what is preventing the repair process from completing (and this most likely has nothing to do with the actual data, more with fields, grids, etc)
Tools > Database > Delete all items
I deleted all items and ran…
I deleted all items and ran repair. It completed successfully in just a few seconds.
In case it's relevant, the file was created by merging 5 files. I used copy-special to transfer the items.
OK, you're left with masking…
OK, you're left with masking data. All item text will become Itemxxx-Fieldyyy. I don't see what anybody could do with such a file.
OK. I'll just make-do with…
OK. I'll just make do with what I have.