Specifying column extended attributes  Altering a table

Chapter 16: Managing the Database

Specifying additional properties for character columns

You can set two additional properties for character columns on the Display property page: Case and Picture.

Specifying the displayed case

You can specify whether PocketBuilder converts the case of characters for a column in a DataWindow object.

StepsTo specify how character data should be displayed:

  1. On the Display property page, select a value in the Case drop-down list:

    Value

    Meaning

    Any

    Characters are displayed as they are entered

    UPPER

    Characters are converted to uppercase

    lower

    Characters are converted to lowercase

Specifying a column as a picture

You can specify that a character column can contain names of picture files (BMP files).

StepsTo 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, PocketBuilder expects to find picture file names in the column, but displays the contents of the picture file—not the name of the file—in reports and DataWindow objects.

    Because PocketBuilder 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).





Copyright © 2004. Sybase Inc. All rights reserved. Altering a table

View this book as PDF