Division by Zero

[Jay R. Ashworth]

On Tue, Jun 19, 2007 at 03:05:05PM -0400, George Simon wrote:
> Good grief! :-)

Calm down, Charlie Brown.  :-)

> I had some records showing "/D0" in a numeric field.

Really?

I wouldn't expect that you *could* *store* /D0 in a real numeric field
in a database.

> 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.

Though, as Jeff notes, that may have broken in later releases.

Ken?  *Why* is it possible to store /D0 in a real numeric field?  And
how is it represented internally?  (And, for extra bonus points, did
the preceding answer change in the 5.0 release train?  :-)

Cheers,
-- jra
-- 
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