exporting fieldname and fieldlenght
Nancy Palmquist
nlp at vss3.com
Fri Apr 22 11:53:18 PDT 2005
Enrique,
Tried the process and got:
file to store shared processes~1
Memo_Number~16
Date~8
Those are the field names and lengths for the file I used.
Here is the processing that worked:
───────────────────────────────────────────────────────────
1 ------- - - - - - - - - - - -
◄ If:
Then: declare num(3,.0);num="1"
2 ------- - - - - - - - - - - -
loop ◄ If: num gt "3" 'set this to highest field number
Then: goto finish
3 ------- - - - - - - - - - - -
◄ If:
Then: gosub saverec
4 ------- - - - - - - - - - - -
◄ If:
Then: filex(1)=fieldname(-,num){"~"{fieldlen(-,num)
5 ------- - - - - - - - - - - -
◄ If:
Then: num=num+"1";goto loop
6 ------- - - - - - - - - - - -
finish ◄ If:
Then: close filex
7 ------- - - - - - - - - - - - - - -
◄ If:
Then: end
8 ------- - - - - - - - - - - - - - -
saverec◄ If:
Then: export ascii filex=(getenv("PFTMP"){"/fields.txt") r=\n
9 ------- - - - - - - - - - - - - - -
◄ If:
Then: return
10 ------- - - - - - - - - - - - - - -
Hope that helps. It is reviewing the current file and I ran this by
doing a call to the table from one record in input processing. It would
run from output, by selecting just one record.
Nancy
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
More information about the Filepro-list
mailing list