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

Compare with Current View Page History

« Previous Version 2 Next »

A code fragment does not support the full range of RDML/X commands. In Version 11, the user is limited to constructs such as If, Case, Dountil, Dowhile, Change, Assign.

At execution time, the code fragment will have read-only access to all columns in the table.

In the following example, the xEmployee table has two columns Surname and GivenNames. Surname is A(20) and GivenNames is A(20). If the Surname was "Smith              " and Surname was "John               ", a simple concatenation virtual would create a virtual column called FULLNAME with a result of  "Smith              John               ".

Using the following code fragment:

#FULLNAME := #SURNAME + ', ' + #GIVENAME

  
the code fragment virtual column FULLNAME will have a result of "Smith, John".

  • No labels