Divide Overflow

[Scott Walker]

In a perfect world, I agree.

 

If the divisor is “0” then don’t do the division in the first place.

 

But in spite of my best efforts over the years, my customers still occasionally get a “\d0” error, normally when running a report, and I have to track it down.  Not a filePro error, but rather a programming oversite on my part.

 

If I knew then (over 30 years ago, when I originally wrote many of my processing tables),  what I know now (now), things would be A LOT cleaner.

 

Regards,

 

Scott

 

Scott Walker

scottwalker1956 at gmail.com <mailto:scottwalker1956 at gmail.com> 

 

 

 

From: fpgroups . [mailto:fpgroups at gmail.com] 
Sent: Wednesday, January 11, 2017 10:06 AM
To: Scott Walker <scottwalker1956 at gmail.com>
Cc: filePro Mailing List <filepro-list at lists.celestial.com>
Subject: RE: Divide Overflow

 

Why do this after the facts?  Adress it at time the value is set and ensure data integrity

 

On Jan 11, 2017 9:59 AM, "Scott Walker via Filepro-list" <filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com> > wrote:

How about in processing check to see if the field contains "\D0"

Example:

If:     7 co "\DO"
Then:   show"@Record# "<@rn<"has a Divide by zero error in field# 7";show""


That seems to find them on my system.

Regards,
Scott

Scott Walker
scottwalker1956 at ramsystemscorp.com <mailto:scottwalker1956 at ramsystemscorp.com> 





-----Original Message-----
From: Filepro-list
[mailto:filepro-list-bounces+scottwalker1956 <mailto:filepro-list-bounces%2Bscottwalker1956> =gmail.com at lists.celestial.com]
On Behalf Of Rami Mantoura via Filepro-list
Sent: Wednesday, January 11, 2017 9:53 AM
To: FilePro Mailing List <filepro-list at lists.celestial.com <mailto:filepro-list at lists.celestial.com> >
Subject: Divide Overflow

Is there a way of checking for a divide overflow in processing (/DO)?

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://mailman.celestial.com/pipermail/filepro-list/attachments/20170111/ca <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170111/caa328f4/attachment.html> 
a328f4/attachment.html>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com <mailto:Filepro-list at lists.celestial.com> 
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com <mailto: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/20170111/57b8a857/attachment.html>