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

Thu Apr 6 07:45:13 PDT 2023

It's been a billion years, but I seem to remember that I setup an alias file to be able to read native filePro tables so I could do whatever I needed to find in the headers, should be able to do same as long as you don't have separate key and data segments, and even that's solvable.

-----Original Message-----
From: Filepro-list <filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com> On Behalf Of Mike Schwartz via Filepro-list
Sent: Thursday, April 6, 2023 10:11 AM
To: filepro-list at lists.celestial.com
Subject: Searching for fields that have /OV or /D0 in them

     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