View Source

Assign the length of the Notes field to the iiiNoteLength virtual column.

1. Select the iiiNoteLength field in the list of Undefined virtuals.

2. In the Details tab, enter the following:

Virtual field type	Code Fragment
Derive value when record is read	Select for Yes

3. Add the following code to Virtual Field Derivation:

     #iiiNoteLength := #iiiEmployNotes.CurChars

Change the code to use your initials.

Your Details tab should now look like this:

Visual LANSA Version 15 > Step 4. Virtual Column for Note Length > step 4 virtual column for note length.png

The code fragment uses an RDMLX intrinsic method CurChars to determine the number of characters in the iiiEmployNotes field and assigns the result to the iiiNoteLength field.

Select #iiiEmployNotes and press F2 to see Features help, showing its Properties, Events, and Methods.

4. The iiiNoteLength column will now be listed under the Read virtuals.