Home » Categories » Solutions by Business Process » System Features

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
  • Release ID: 5.9
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Data Interchange Omit First Row from Import
Viewed 1977 times since Fri, May 27, 2016
Application Memos – Warning or Note
Viewed 1093 times since Wed, Jun 13, 2012
General System Options - List of Users Database
Viewed 132 times since Tue, Oct 15, 2024
Ledger Enquiry - Prevent Auto Close of Associated File Folder on Enquiry
Viewed 104 times since Wed, Oct 23, 2024
Discount and Supplier Matrix Prevent Sale of Items to Selected Customers
Viewed 2188 times since Fri, May 20, 2016
Screen Size Settings
Viewed 2332 times since Tue, Jun 12, 2012
Landing Pages - Sorting and Grouping on Table Items
Viewed 150 times since Thu, Oct 17, 2024
Application Enquiry Screen Tabs
Viewed 1440 times since Wed, Sep 21, 2016
General Application Pick Lists
Viewed 2271 times since Wed, Sep 21, 2016
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 4597 times since Fri, Jul 21, 2017