Sort/Selection processing

John Esak john at valar.com
Wed Jun 16 11:46:21 PDT 2010


It sounds like you might still be in filePro when you're trying to open the
file. If so, you must CLOSE it first.  So issue a CLOSE statement and see if
you cn then open the file first. 

John

> -----Original Message-----
> From: Harold [mailto:haroldef at sbcglobal.net] 
> Sent: Wednesday, June 16, 2010 12:01 PM
> To: john at valar.com
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Sort/Selection processing
> 
> On 6/15/2010 3:51 PM, John Esak wrote:
> >
> > Yes, I realized right away that @ts wouldn't have a meaning 
> other than Total
> > Records Processed, not Total Records Selected.  I think it 
> *would* be useful
> > in this context.  Not *real* useful... But somewhat, 
> maybe... Sometimes...
> > Perhaps. Oh, okay, it's pretty much not to useful a thing 
> to know, other
> > than to just know it? Since it has no relation to how many 
> you actually
> > select, you couldn't use it for much of anything.
> >
> > John
> >
> 
> Hi John,
> 
> I am still working on my problem--I can create the CSV file, 
> but haven't been able to 
> open the CSV file while in filepro, using Excel, after the 
> CSV file has been created.
> 
> I use @ts to see how many records have been selected, and as 
> each record has been 
> sent to the CSV file I increment a variable field rn.  When 
> rn is equal to @ts I try 
> to open CSV.
> 
> To prove that @ts is the number of records selected I have 
> created the JPG file 
> attached.  Note at the bottom left where it shows @ts, which 
> contains the number of 
> records selected, which is that same number as that above.
> 
> Take Care,
> 
> Harold
> 
> >
> >
> >> -----Original Message-----
> >> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> >> Sent: Tuesday, June 15, 2010 3:49 PM
> >> To: john at valar.com
> >> Cc: filepro-list at lists.celestial.com
> >> Subject: Re: Sort/Selection processing
> >>
> >> On 6/15/2010 2:12 PM, John Esak wrote:
> >> [...]
> >>> I will assume that @ts has no value either on the -v table.
> >> Although, who
> >>> knows (besides Ken :-) maybe it does. In which case, you
> >> could set an
> >>> incrmenting counter for every record encoutnerd selected or
> >> not and when @ts
> >>> equalled this counter, you'd be done with the -v processing.
> >> [...]
> >>
> >> I'd have to check is @TS has any value during sort/select
> >> processing.  But,
> >> even if it did, what would it mean?
> >>
> >> Consider this:
> >>
> >> I hand you my Rolodex, and ask you to pull out all the
> >> clients from New
> >> York.  Part-way through, I ask you "how many New York clients
> >> are in my
> >> Rolodex, and have you gotten all of them yet?"
> >>
> >> --
> >> Kenneth Brody
> >>
> >
> > _______________________________________________
> > Filepro-list mailing list
> > Filepro-list at lists.celestial.com
> > http://mailman.celestial.com/mailman/listinfo/filepro-list
> >
> 
> 
> 



More information about the Filepro-list mailing list