In order to bring you the best possible user experience, this site uses Javascript. If you are seeing this message, it is likely that the Javascript option in your browser is disabled. For optimal viewing of this site, please ensure that Javascript is enabled for your browser.
Login  |   Cloud ERP  |   Home  |

  •     QAD Glossary

  • Using View Maintenance
    View Maintenance (36.20.18) illustrates View Maintenance (36.20.18).

    View Maintenance (36.20.18)
    Select or enter a view name.
    Enter a label term in Description Term. The long label contained in this term is displayed as the view label.
    In User IDs/Groups, enter a user ID to limit user access to the view (optional). You can enter multiple user IDs by separating them with commas.
    Press Go.

    View Maintenance, Table Selection
    The number you enter in Sequence controls the order in which the table defined in Table is joined to the view.
    Enter a table name.
    If the sequence is not 1, specify the type of join, either inner or outer. The Join Type field is only enabled when the sequence number is greater than 1.
    Enter or edit the phrase to join the tables. Use proper Progress syntax. Do not include a Where verb. Join phrases express the field relationships between tables (see Creating a View by Joining Two Tables). For a faster display of fields, use indexed fields in the Join Phrase.
    Press End.

    View Maintenance, View Field Data
    In Field Name, enter a field from one of the tables in the view or enter a local variable. When entering a local variable, name it local-varnn, where nn is a number incremented by one from the last defined variable.
    For example, you see from the look-up browse that the last local variable was local-var05; you name your local variable local-var06. Use local variables when you want to return a value resulting from an operation on two fields; for example, the quantity required minus the quantity open. Define the operation in Expression.
    If you entered a local variable in Field Name, enter its Label Term, Format, and Data Type.
    Note: Search for a label term by entering a portion of a label, then use Next/Previous to display available records.
    If Field Name is a local variable, you can enter Progress syntax in Expression to define the local variable. Valid expressions include:
    field1 + field2 (computation, where field1 and field2 are fields within the record)
    >, <, >= (operands that perform comparisons)
    Progress functions, such as substring (field1,1,4) or round ( field1,1)
    Note: Incorrect syntax terminates your session if you attempt to use the view.