RJ edit

[Kenneth Brody]

Quoting gliderman.one (Tue, 09 Aug 2005 12:22:24 -0400):
[...]
> My processing using about 85 dummy data records works fine using the RJ
> edit.
> Customer's processing containing about 4,000 records does not.
> Customer's  data  says it begins selecting records, but freezes without
> doing so.

How and where does it "freeze"?

> Rebuilding the RJ index, deleting the RJ index and rebuilding it did not
> change the selection freeze. I looked for higher and lower ascii
> characters in a record but found none.
> I changed the RJ field edit to .0 in the customer's file and  rebuilt
> the index.  It then worked fine.
>
> Is there a rule that the RJ edited data will not sort properly; similar
> to the rule that the $ edit field  data should not be used to do math?

Indexes can be built on any field type other than memo and blob.  Also,
it's not really a "rule" about the "$" edit, but more of a "suggestion".
filePro can do math on "$" fields, but why incur the overhead, when you
could use real numbers instead, and only use "$" for output as intended?

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com