Searching for fields that have /OV or /D0 in them

[Richard D. Williams]

Hi Mike,

The /D0 and /OV are not "real" values in  the typical sense.
You might try looking for values outside the typical range allowed by 
the edit.
Or you might try building a demand index on those fields.

Finding the affected records is not as difficult and locating the cause.
Somewhere there is a mathematical formula that did not consider that a 
divisor could be blank or zero.

Richard


On 4/6/2023 9:10 AM, Mike Schwartz via Filepro-list wrote:
>       One of my customers entered some bad data into their databases that
> caused /D0 (divide by zero) and /OV errors in a lot of records.  All of the
> fields involved have numeric edits such as (6,#), (10,.2), etc.
>
>   
>
>       Other than manually eyeballing several thousand records for fields that
> show either /D0 or /OV, I was trying to use "Scan for Records" to search for
> all the damaged records;  something like:
>
>                                                  
>
>           Field Number: 3  │ Allocated Quantity
>
> Enter Relationship: co │  contains
>
>           Enter value:   /D0│
>
>   
>
>          However, that doesn't work because I can't put /D0 or /OV in as a
> field value.
>
>   
>
>        I tried to write a sort/selection processing that puts the numeric
> value into a non-numeric dummy field, then search that for /D0 or /OV, but
> that didn't work:
>
>   
>
>         If:
>
> Then:   ZZ(10,*)=3
>
>         If:   ZZ co "D0" or ZZ co "OV"
>
> Then:   SELECT; msgbox "Found record" <@RN
>
>   
>
>       Any suggestions?
>
>   
>
> Thanks!
>
>   
>
> Mike Schwartz
>
>   
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20230406/16b79409/attachment.htm>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list