Processing to add/create real fields in an existing file

George Simon flowersoft at compuserve.com
Sun Aug 15 17:55:14 PDT 2004


I don't think that can be done.
If you need those fields, and they are filePro files, why don't you just add the most number of fields you would need to the file and the store the info into them.  If no info is stored, no big deal.  Mass storage is very cheat these days.

  ----- Original Message ----- 
  From: John Koenig 
  To: Filepro List 
  Sent: Sunday, August 15, 2004 8:17 PM
  Subject: Processing to add/create real fields in an existing file 


  Filepro Experts:

   I import files that contain information regarding pools of mortgages, which I then analyze using Filepro. 
  These files do not have a uniform format as they are from various mortgage lenders.

  The processing that I have written requires that the output be stored in real fields within the file that I have imported. Therefore
  declaring values will not work. At least I don't see how it would solve my problem. As a consequence after importing a file I find myself MANUALLY entering these fields time (various date fields such date next interest change etc) again and again.

  Is there a simple way to add  real fields to a file via a filepro processing table (dos/windows version)? 

  For example:

  Say I have a mortgage file (named "mortgage") with the following fields.

  1)  MortgageAmount   10, $
  2)  Rate                       6, F
  3)  Term                       3,.0
  4)   ClosingDate             8,yymd

  I would like to write a filepro process (dos version)  that would automatically add the following fields to the map so that I can calculated the maturity date and store it in the file. The process can reside in the mortgage file itself since I always import the new
  data into the same file for initial processing with the standard processing table I have written.

  5)   maturityDate            8,yymd
  6)   maturityMonth         3,*

  My thanks in advance for any help!

  Regards,

  John Koenig





------------------------------------------------------------------------------


  _______________________________________________
  Filepro-list mailing list
  Filepro-list at lists.celestial.com
  http://mailman.celestial.com/mailman/listinfo/filepro-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20040815/74d9df2e/attachment.html


More information about the Filepro-list mailing list