Filepro-list Digest, Vol 77, Issue 20

Boaz Bezborodko boaz at mirrotek.com
Wed Jun 16 13:46:26 PDT 2010


> Date: Wed, 16 Jun 2010 11:00:58 -0500
> From: Harold <haroldef at sbcglobal.net>
> Subject: Re: Sort/Selection processing
> To: john at valar.com
> Cc: filepro-list at lists.celestial.com
> Message-ID: <4C18F53A.7040208 at sbcglobal.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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
>   
If you aren't waiting until the process table finishes (and closes all 
open files) then the file will be locked by FilePro and Excel won't open 
it.  You have to close a file being exported using the CLOSE command 
before you can access it.

Boaz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20100616/a89963ba/attachment.html 


More information about the Filepro-list mailing list