Sort/Selection processing

Harold haroldef at sbcglobal.net
Wed Jun 16 09:00:58 PDT 2010


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
>


-------------- next part --------------
A non-text attachment was scrubbed...
Name: RecordsSelected.jpg
Type: image/jpeg
Size: 49919 bytes
Desc: not available
Url : http://mailman.celestial.com/pipermail/filepro-list/attachments/20100616/874517dd/attachment.jpg 


More information about the Filepro-list mailing list