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

[James Flanagan]

Mike, 

Try searching for values either “less than” 0 or “greater than”  9 (or how many ever 9’s complete the edit type).  I cannot recall if it is considered greater or less than, but I have run into this in the past.  Good luck.  


James Flanagan
Flantec.com <http://flantec.com/>

email:	James at Flantec.com <mailto:James at Flantec.com>
mobile:	760-458-8498
home: 	219-221-6219
text:		7604588498 at txt.att.net <mailto:7604588498 at txt.att.net>

Skype:	Flantec
ichat:	James at Flantec.com <mailto:James at Flantec.com>	

home:	1901 Cidermill Road
		Michigan City, IN 46360



> On Apr 5, 2023, at 11:14 PM, Mike Schwartz via Filepro-list <filepro-list at lists.celestial.com> 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/20230405/6c078b91/attachment.htm>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20230406/051c59b3/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PastedGraphic-1.tiff
Type: image/tiff
Size: 19328 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20230406/051c59b3/attachment.tiff>