T-Table Description as Data Item


Datafile Software

T-Table Description as Data Item

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.


Custom Fields

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