FW: Export question

Kenneth Brody kenbrody at bestweb.net
Tue Sep 13 11:47:15 PDT 2005


Quoting Cindy Youngman (Tue, 13 Sep 2005 14:37:00 -0400):
[...]
> BTW - running 4.8 on SCO Openserver V
[...]
> I have a process in the beginning for the process to clears my 3 files
> and I am using an append flag on the export.  After each line exported
> I am doing a "write" and a "close" since I am using 3 separate files
> for the same record.  This all works great HOWEVER my first file
> contains 50 fields and my second 2 files only 6-8 fields.  When the
> files are created, I get the extra "","","","" etc on the end of each
> line up to 50 for my smaller files.
>
>
> My question is:
>
> Is there some way to stop this from happening?  Is there a way of
> resetting between each export so the structure is not extended to
> the same length as my first file?

Upgrade to 5.0.14 or later:

(All) #709

    EXPORT ASCII/WORD would always export the same number of fields,
    regardless of whether the fields were assigned to on each record,
    even if they were only referenced in a comment.

    Now, filePro will only export the number of fields as the highest-
    reference field actually assigned.

    For example:

        If:
      Then:  out[1] = 1 ; out[2] = 4
        If:  xx = "y"
      Then:  out[3] = 3 ; out[4] = 4
        If:
      Then:  ' out[5] = 5

    filePro would previously always exported 5 fields.  Now, if x="y"
    is true, it will export 4 fields, and if false will export 2 fields.

    To revert back to the old behavior, set PFEXPORTALL=ON.

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com


More information about the Filepro-list mailing list