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.


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
Ledger Enquiry - Additional CRM Categories
Viewed 3803 times since Fri, Jun 8, 2012
Forecast Dates - Additional Options
Viewed 1044 times since Fri, May 27, 2016
Route Map Links
Viewed 1216 times since Tue, Jun 12, 2012
Ledger Enquiry – Update Sales / Purchase Accounts
Viewed 477 times since Wed, Jun 13, 2012
Screen / Spool Report Hyperlinks
Viewed 1310 times since Tue, Jun 12, 2012
Pick Lists - Increased No of Display Items
Viewed 1400 times since Wed, Sep 21, 2016
Ledger Enquiry – Improved Scans Option
Viewed 518 times since Wed, Jun 13, 2012
Connection to SQL Server via ODBC and SQL Log Housekeeping
Viewed 1229 times since Fri, Jul 21, 2017
Application Graphs on Main Toolbar
Viewed 1161 times since Tue, Jun 12, 2012