Division by Zero

[George Simon]

Good grief! :-)
I had some records showing "/D0" in a numeric field.
I was looking for a way to search through all the records in the file
and find the ones that had a "/D0" in that field.  Since filePro does
not let you enter a "/" or a "D" into a numeric field when scanning for
records, I was asking if anyone knew (I remember reading about it many
years ago) of a "trick" to accomplish what I was trying to do.  Barry
Wiseman suggestion of searching for a value higher than the highest
possible value in that field ( gt "999999.99" ) did the trick.


-----Original Message-----
From: filepro-list-bounces+george=worldest.com at lists.celestial.com
[mailto:filepro-list-bounces+george=worldest.com at lists.celestial.com] On
Behalf Of Jay R. Ashworth
Sent: Tuesday, June 19, 2007 2:22 PM
To: filepro-list at lists.celestial.com
Subject: Re: Division by Zero

On Tue, Jun 19, 2007 at 01:09:51PM -0400, George Simon wrote:
> The answer is: greater than the largest possible number in that field.
> The correct answer was first provided by Barry Wiseman in a PM.
> Thanks also to Jeff and Nancy for responding.
> 
> It is odd that filePro manages to enter a /D0 in the numeric field but
> does not allow you to search for it. :-)

"Search" still confuses me, even after reading most of the responses.

Is your question actually this, George?

	"How do I test a numeric field that was the LHS of an
	assignment statment where the RHS was a mathematical
	expression, and I want to find out if the result was '/D0'?"

IE:

::qq(5,.0)=xx/yy:
:qq ... what goes here?:show "yy was zero; divide error":

Was that what you were looking for?

Or did you mean:

::6=xx/yy:
:6 ... what goes here?:show "yy was zero; divide error":

That is, using a real field as the target?  (Does the result differ?)

Or did you mean something else entire?

Cheers,
-- jr '3 years on tier-1, yes' a
-- 

Jay R. Ashworth                   Baylink
jra at baylink.com
Designer                     The Things I Think
RFC 2100
Ashworth & Associates     http://baylink.pitas.com
'87 e24
St Petersburg FL USA      http://photo.imageinc.us             +1 727
647 1274
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list