RJ edit

[GCC]

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com 
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf 
> Of gliderman.one at verizon.net
> Sent: Tuesday, August 09, 2005 1:07 PM
> To: Kenneth Brody
> Cc: filepro-list1
> Subject: Re: RJ edit
> 
> Kenneth Brody wrote:
> 
> >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"?
> >  
> >
> 
> Using  -a  to select all records, the freeze occurred when  10 
> records were read and  0 selected.
> 
> I changed the field edit from RJ to  .0  and rebuilt the 
> index and it worked fine.
> I changed the field edit from .0 back to  RJ and rebuilt the 
> index and it works fine.
> 
> So, whatever  was causing it, I have changed by changing the 
> field edit?
> 
> If you can guide me as to what to look for, I can copy the 
> malfunctioning file again from a cd.
> 
> Charles Day
> 
Just as an experiment, restore the file and then run freehn against it.  Rebuild
you index and then try your report.

If I recall correctly, rj will right justify anything placed in the field.  If
this is strictly a numeric field, why not leave it as (2,.0)?

My best guess about your problem is that you may have had bad data in this field
and changing the format eliminated the data when chagrining the value from ASCII
to numeric. 

Richard Kreiss
GCC Consulting