Specifications

Working with tables
90 InfoMaker
Specifying additional properties for character columns
You can also set two additional properties for character columns on the Display
property page: Case and Picture.
Specifying the
displayed case
You can specify whether InfoMaker converts the case of characters for a
column in a report or form.
❖ To specify how character data should be displayed:
• On the Display property page, select a value in the Case drop-down list:
Specifying a column
as a picture
You can specify that a character column can contain names of picture files.
❖ To specify that column values are names of picture files:
1 On the Display property page, select the Picture check box.
When the Picture check box is selected, InfoMaker expects to find picture
file names in the column and displays the contents of the picture file—not
the name of the file—in reports and forms.
Because InfoMaker cannot determine the size of the image until runtime,
it sets both display height and display width to 0 when you select the
Picture check box.
2 Enter the size and the justification for the picture (optional).
Altering a table
After a table is created, how you can alter the table depends on your DBMS.
You can always:
• Add or modify InfoMaker-specific extended attributes for columns
• Delete an index and create a new index
You can never:
• Insert a column between two existing columns
Value Meaning
Any Characters are displayed as they are entered
UPPER Characters are converted to uppercase
lower Characters are converted to lowercase