Exact Matches...

[Stanley - stanlyn-com]

Hi Barry,

> I never realized the need until several years too late.

It's never too late for things this important... or is it?

Thanks, Stanley




-----Original Message-----
From: filepro-list-bounces+stanley=stanlyn.com at lists.celestial.com
[mailto:filepro-list-bounces+stanley=stanlyn.com at lists.celestial.com] On
Behalf Of Barry Wiseman
Sent: Wednesday, April 25, 2012 5:14 PM
To: filepro-list at lists.celestial.com
Subject: Re: Exact Matches...

On 4/25/2012 4:58 PM, Stanley - stanlyn-com wrote:
> Hi,
>
>
>
> How do you find records via the interface's "2-Scan for Records" that 
> match exactly. That is the right side must match the left side exactly.
>
>
>
> Here is an example:
>
>
>
> The table has 165,000 records where the item # is "Sales Tax" and 
> there are a few records where the value is "Sales Ta".  Every way I've 
> tried, it returns all the "Sales Tax" records and there is hours and 
> hours of wading to do.  I know how to get it via code, but this needs 
> to be user friendly on their interface.  I was hoping to see an "EX" 
> option, like eq, lt, gt, ne, and etc to handle this, but its not here.
>
>
>
> Is there anything like "Set Exact on" that could be used for this?  I 
> hope so.
>
>
>
> Thanks, Stanley
>
>
I agree with you, there should have been an "EX" relation -- and as I was a
member of the design team I accept a share of the blame for its absence, I
never realized the need until several years too late.

Fortunately, the workaround is often easy, as in your case.  Search for "eq
Sales Ta" AND "ne Sales Tax."
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list