Division by Zero

[Jeff Harrison]

--- "Jay R. Ashworth" <jra at baylink.com> wrote:

> 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?  :-)
> 

On a hunch I just took a look at my example where the
gt "99999999" did not work.  I noticed that the edit
that I used was ".0"  I tried it again with ".2" and
it works!  So there is your answer I guess. 
Presumably the gt "largevalue" only works in decimal
operations.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The fastest and
easiest ways to generate filepro exports and imports.


       
____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search 
that gives answers, not web links. 
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC