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

Jose Lerebours fp at fpgroups.com
Thu Oct 16 07:00:50 PDT 2008


Kenneth Brody wrote:
> 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.
> ==========
> 

Well, that explains it!

Running SCO UNIX based 5.0.13D4


Thanks,




More information about the Filepro-list mailing list