Is this normal? Unexpected export output when using multiple export commands ...

Kenneth Brody kenbrody at bestweb.net
Thu Oct 16 06:51:52 PDT 2008


Quoting Jose Lerebours (Thu, 16 Oct 2008 09:31:01 -0400):

> I am working on a relative simple routine where potentially, two files
> could be created.  I am using two sub-routines to handle each potential
> file.  fileA would be a data file if all conditions are met and fileB is
> an error file if an error is encountered.
>
> The routine where fileA is created exports about 65 fields.  The routine
> where fileB is created exports two fields.
>
> I just noticed that when fileB is created, there is lot of blank fields.
>
> I am using gosub command to create the export file using:
[...]

Am I correct in assuming that you are using the same export statement
for both exports?

How old is your version of filePro?

This is from the 5.0.14 readme file:

==========
(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