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