Data Type - Define
the application field type. A field type text it accepts letters, numbers and special characters.
Case Settings - Convert the field font case. All upper case, if the select option is Upper Case, all lower case if the select option is Lower Case, only first letter of first word to upper case, if the select option is Capitalize first word,
first letter of each word to upper case if the select option isCapitalize all word.
HTML Content - Define the field content as
HTML. An HTML Content field process html tags.
Grid Mask - Define the field grid mask. For example, to format a phone number with parentheses and dashes. The mask uses the characters "X" and "Z", where X enable zero and Z disable zero.
SQL Type - Determine the field type in database.
Grid Lookup
Used to modify the display of a grid field. For example, a field gender in the database with values M or F is displayed as Male or Female (see lookup manual) or the display values retrieve from a database table (see lookup automatic).
Before Lookup
After Lookup
Grid Lookup - Automatic
Lookup used to modify a field display dynamically, retrieving the values from a database table.
Figure3: Automatic Grid Lookup Interface.
Attributes :
SQL Select Statement - Define the SQL statement to retrieve the grid field display value. The statement has the following format "SELECT display_field FROM table WHERE key_field = {grid_field}".
The grid field should be enclosed in curly brackets. During execution the field enclosed in curly brackets is substituted by its table value.
Multiple Options - Select Yes when the SelectCommand entered returns more than one informed value.
Delimiter - Define the delimiter between the multiple values returned by the Select Command. Use this option when Multiple Options = Yes.
Use lookup in:
Grid
Apply the lookup in all grid types (HTML, PDF, XML , CSV and RTF).
Summary
Apply the lookup summary only (HTML and PDF).
Both
Same as selecting Grid and Summary.
Default Value - Define a default value used when the select command does not return any value.
Display original and lookup value - Select No, to display only the Select Command return value. Otherwise, the field original value and the Select Command return value separated by the character defined in Separated by.
Separated by - Define the characters used to separate the field original value and the Select Command return value. Use this option when Display original and lookup value = Yes.
Choose connection - Select a different connection available in the project.
Grid Lookup - Manual
Lookup used to modify a field display with predefined values.
Figure1: Manual Grid LookupInterface.
Attributes :
Lookup Types - Define the lookup operation mode: Single Value , Multiple Values (Delimiter), Multiple Values (Position) and Multiple Values (Binary).
Insert - Add the
values entered in Label and Value to the value list .
Update - Update selected item.
Remove - Remove selected item.
Clear - Clear the attributes.
Save - Save the values entered to the "lookup definitions" list to be used afterwards (for reuse).
Load lookup definitions - Loads a pre-defined Values List to use in lookup.
Use lookup in:
Grid
Apply the lookup in all grid types (HTML, PDF, XML , CSV and RTF).
Summary
Apply the lookup only in (HTML and PDF).
Both
Same as selecting Grid and Summary.
Default Value - Define a default value used when the selected command does not return any value.
Display original and lookup value - Select No, to display only the Label value . Otherwise, the field original value and the Label value are displayed separated by the character defined in Separated by.
Separated by - Define the characters used to separate the field original value and the Select Command return value. Use this option when Display original and lookup value = Yes.