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

[Mike Schwartz]

     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>