summary sheets from temp file

[Richard Kreiss]

Top post:

filePro 5.7.03.06

I am having a similar problem with an index sorted on and account # - 1234-12345, a status field(1,.0) and a dates field(10,mdyy/)

The index is X and when entered through IUA the first record for that person with a blank status field is displayed.

>From an output process in another file, doing a lookup to that file using the account #, the record found is the next record in the sequence.

I have checked this a number of time with the debugger and different account # records and get the same results.  

You may be having a similar problem.


Richard Kreiss
GCC Consulting

Office: 410-653-2813




> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
> [mailto:filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com] On
> Behalf Of scooter6 at gmail.com
> Sent: Monday, July 14, 2014 3:12 PM
> To: Bruce Easton
> Cc: filepro-list at lists.celestial.com
> Subject: Re: summary sheets from temp file
> 
> Here is the 'structure' part of the file that's pertinent
> 
> Field 1 = 4,#  is the client number   ' in the examples here, that is 2435,
> 3194 & 5498  - this is what it should sort on - a new page for each unique
> client number Field 2 = 4,allup  is the account number  'in the examples here,
> that is what comes after the "-" 0001, 0002 for client 2435, 0143, 0144, 0145
> for client 3194
> Field 3 = 9,allup  is the two fields combined  with a "-" in middle   'i.e.
> 2435-0001, 2435-0002, 3194-0143, etc
> 
> So since the file has the client number in a field already, I have it sorting on
> field 1 with a length of 4 - which appears to be okay, since it's doing what I
> want it to do, except it's not finding the 'lowest'
> account number...otherwise, everything works fine haha
> 
> 
> 
> On Mon, Jul 14, 2014 at 3:04 PM, Bruce Easton <bruce at stn.com> wrote:
> 
> > Scott - check the sort screen for this - did you sort on Account
> > Number, but only for a length of four?
> >
> > Bruce
> >
> > On 7/14/14 2:55 PM, scooter6 at gmail.com wrote:
> > > adding 'end' in @sbrk1 had no effect - aa is still equal to ab on
> > > all pages
> > >
> > >
> > > On Mon, Jul 14, 2014 at 2:47 PM, Bruce Easton <bruce at stn.com
> > > <mailto:bruce at stn.com>> wrote:
> > >
> > >     Ah yes, the lack of "end" for @sbrk1 is probably why your aa is being
> > >     set to your ab.
> > >
> > >     Bruce
> > >
> > >     On 7/14/14 2:33 PM, Kenneth Brody wrote:
> > >     > On 7/14/2014 1:57 PM, scooter6 at gmail.com
> > >     <mailto:scooter6 at gmail.com> wrote:
> > >     >> Ken,
> > >     >>
> > >     >> Here is what my output processing looks, with sort on client
> > >     number (4
> > >     >> characters and subtotal) and then full account number
> > >     >> Everything works great except the 'starting (lowest)' number -
> > >     that is
> > >     >> coming out blank
> > >     >>
> > >     >> :1="":end::gP*P|VW_L&4foSDs:
> > >     >> @sbrk1::aa(4,#)=mid(3,"6","4")  'this is the lowest number:
> > >     > aa(4,#,g)=mid(3,"6","4") ; end
> > >     >
> > >     >> @wbrk1::ab(4,#)=mid(3,"6","4") 'this is the highest number:
> > >     >> ::lookup cli=client  k=1   i=A -nx:
> > >     >> ::ac(30,uplow)=cli(2) ' this grabs the name of the client:
> > >     >> ::end:
> > >     > [...]
> > >     >> Any idea why 'aa' starting number is coming back blank?
> > >     > [...]
> > >     >
> > >     > No ",g" flag.
> > >     >
> > >
> > >
> > >     _______________________________________________
> > >     Filepro-list mailing list
> > >     Filepro-list at lists.celestial.com
> > >     <mailto:Filepro-list at lists.celestial.com>
> > >     Subscribe/Unsubscribe/Subscription Changes
> > >     http://mailman.celestial.com/mailman/listinfo/filepro-list
> > >
> > >
> >
> > -------------- next part -------------- An HTML attachment was
> > scrubbed...
> > URL:
> > http://mailman.celestial.com/pipermail/filepro-list/attachments/201407
> > 14/c48dae8d/attachment.html
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > Subscribe/Unsubscribe/Subscription Changes
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-
> list/attachments/20140714/1a95343c/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list