Export dif multiple lines

Jose Lerebours fp at fpgroups.com
Wed Sep 17 10:42:36 PDT 2008


Richard Hane wrote:
> Is it possible to export a dif file with multiple (2 in this case) lines 
> per filepro record?
>  
> IE. 1st line part nmr, description, qty in stock, etc
> 2nd line skip 3 columns the plant comments, controller notes
>  

Barry and Bill provided workable solutions, here is another twist:


1) Write routine to open export record
    export dif ofile = (fn) ....
2a) Set fn to target file name
2b) gosub to routine (1)
2c) set values as needed
3a) Set fn to target file name (if diff from 2a)
3b) gosub to routine (1)
3c) set values as needed

This approach allows you to easily fall through a session of code and 
change your target by simply gosub'ing to the routine where the export 
is executed.  It can also be used to export to multiple files (as you 
know, filePro has a problem with multiple export or export+same_alias 
commands within the same routine - or so I think to recall) and export 
as many instances of the same record as you need.

I do not have a filePro server available so I could not include what the 
code would look like but hope this gives you a clear enough idea.

Good luck!


Jose Lerebours


More information about the Filepro-list mailing list