When showing table items on screen the system shows the value followed by the text description associated with it. When showing on reports / documents then generally only the value is shown, similarly when outputting to a CSV- file only the value is output.
A new feature allows for the creation of a sub-item based on the table value but the sub-item will contain the table description and not the value. This can be displayed in screens, reports, and documents plus be used in lists and CSV output.
Installation
Restructure a Database
When creating a sub-item you can now base this on a T-Table item.
When defining a sub-item you are asked for three parameters:
qItem – data item this is to be based upon
qStart – would usually be ‘1’ when working on table items this is the character position at which the sub-item is to start.
qSize – maximum of ‘32’ for table items (if start
at position 1) otherwise remaining balance of field or less as required.
Article ID: 266
Created On: Wed, Jun 13, 2012 at 11:07 AM
Last Updated On: Tue, Jun 20, 2023 at 6:14 PM
Online URL: https://kb.datafile.co.uk/article/t-table-description-as-data-item-266.html