Salesforce

Pictures - Data Items (Magic xpa 2.x)

« Go Back

Information

 
Created ByKnowledge Migration User
Approval Process StatusPublished
Objective
Description

Pictures - Data Items (Magic xpa 2.x)

A picture is a string of characters that tells Magic xpa how to define the format of an attribute. You can specify the picture format in the Picture dialog box, which is accessed from the Picture property in the Details section of the Column or Properties sheet. Magic xpa automatically defines the most commonly used pictures for data items that have known attributes (for example, dates).

You may be required to specify a picture in three different situations:

  1. To define the attribute’s size and default form in the Model or Data repositories. This way you control the attribute’s data input and output representation.

    Parameter Name

    Attribute

    Picture

    Meaning

    Title

    Alpha

    15

    A 15-character alphanumeric parameter

    ID Number

    Numeric

    ### or 3

    3-digit integer numeric parameter

    Due Date

    Date

    MM/DD/YY

    Date parameter format for input and output

    Percent

    Numeric

    ###.## or 3.2

    A number parameter with 3 whole digits and up to 2 decimals.

  2. To override the default format of an attribute to display it on a screen or report form.

  3. To specify data conversion rules for Magic xpa data conversion functions. For example, the Str function translates a numeric attribute to a string representation. Therefore Str (712.93, '###.####') returns the string 712.9300.

The picture string is composed of three basic types of characters:

  1. Functional directives

  2. Positional directives

  3. Mask characters

Each Magic xpa attribute has its own set of picture directives.

Related Topics

Reference
Attachment 
Attachment