You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

[ |../../index.htm#lansa/ugub_30063.htm]
You are here:

Concatenation Field Examples

This screen demonstrates the use of the "Concatenation of field(s)" option and how it may be used in joining together a number of fields (real or virtual) to form a virtual field after input from a file.
Using the idea of the chart of accounts example we will switch the real and the virtual fields around so we now have 3 "real" fields COMPNO (alpha length 2), DIVNUM (alpha length 2) and COSTCT (alpha length 4) and join them together to form the "virtual" field CHTACC (alpha length 8):
 

 
 DC@P201606          Concatenation of field(s)                         
 
 File: ACCMST     Accounts Master file                                 
 
 Virtual field: CHTACC     Chart of accounts number             
 
 Derive "virtual" field on input from file . . .  YES  YES, NO       
 Setup "real" field before output to file  . . .  NO   YES, NO       
                                                                       
         Using fields                                                  
          COMPNO      
          DIVNUM      
          COSTCT      
                      
                         +  
 
 Fnn=Help  Fnn=Exit  Fnn=Cancel  Fnn=Messages  Fnn=Change  Fnn=Delete  
 

 |
[ |../../index.htm#lansa/ugub_30063.htm]

  • No labels