<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<blockquote
cite="mid:mailman.22.1276712510.4808.filepro-list@lists.celestial.com"
type="cite">
<pre wrap="">
Date: Wed, 16 Jun 2010 11:00:58 -0500
From: Harold <a class="moz-txt-link-rfc2396E" href="mailto:haroldef@sbcglobal.net"><haroldef@sbcglobal.net></a>
Subject: Re: Sort/Selection processing
To: <a class="moz-txt-link-abbreviated" href="mailto:john@valar.com">john@valar.com</a>
Cc: <a class="moz-txt-link-abbreviated" href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>
Message-ID: <a class="moz-txt-link-rfc2396E" href="mailto:4C18F53A.7040208@sbcglobal.net"><4C18F53A.7040208@sbcglobal.net></a>
Content-Type: text/plain; charset="iso-8859-1"
On 6/15/2010 3:51 PM, John Esak wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap=""><!---->
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
</pre>
</blockquote>
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.<br>
<br>
Boaz<br>
</body>
</html>