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