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

  • Creating Browses
    Use Browse Maintenance (36.20.13) to create browses, which display selected data in the form of a table.
    When you create a browse, it is saved in your working directory as a source-code file. The source-code name is the first two characters of the name you entered, then the letters br or lu (depending on whether you selected power or look up), then any remaining numbers from the name you specified, then the extension .p.
    Example: You create a power browse and name it ap010; the system names the code apbr010.p. If you selected both power and look-up browses, the system generates two source-code files: apbr010.p and aplu010.p.
    Although you do not need to compile the source code of the browse, you should for better performance. If other users on your network want to use your browse, you must compile it and move it to the network directory. Use the Progress editor to compile the browse.
    Note: You can access the Progress editor only if your PROPATH is correctly set up to access source files.

    Browse Maintenance (36.20.13)
    To create or modify a browse:
    Select or enter a name for the browse. To name the browse, enter two letters and press Enter. The system gives the browse a name that increments by one the number in the file name of the last browse created.
    Note: Use the existing module mnemonics or make up your own.
    Press Go. To preview an existing browse, press Enter. Otherwise, press Go again.
    Important: Previewing a browse can be a time-consuming process because the system generates and displays the browse in runtime.
    Enter a label term in Description Term. The long label contained in this term is displayed as the title in the browse window.
    Indicate whether this is a power browse, look-up browse, or both.
    In View, enter the name of an existing view or a primary table whose data the browse displays. You can see only those views you have access to. If a view exists for a table and the view name is the same as the table name, you have access to only those fields that are available in the view.
    Note: The view name you enter in View must already be defined in View Maintenance, or you must enter a primary table name.
    In the Where field, type the selection criteria (optional) to limit the browse’s search to records that meet a certain condition. The criteria in Browse Maintenance (36.20.13) would display only inventory balances of bolts greater than 100. Do not put a period (.) at the end of the criteria, because the system adds a no-lock no-error statement to the criteria.
    Press Go.

    Browse Maintenance, Field Select
    Fields from the view or primary table entered in the Browse Data frame display in Available Fields. Include up to 20 fields in your new browse.
    In the Windows interface, select fields to include in your browse by clicking on them and choosing the Add button. To view help on an available field, click on the field and choose the Field Help button.
    In character mode, select a field to include in your browse by using the Up and Down keys to locate it and then press Enter. Multiple fields can be selected. Use the Tab key to choose the Add, Field Help, or Done buttons or to navigate between the Available Fields list and the Selected Fields list.
    You can use the Move Up and Move Down buttons to arrange the fields in the Selected Fields list. If you want to remove a field from the Selected Fields list, select it and choose the Remove button.
    When you have arranged the fields in the order you want, press Go.
    Enter the column number to take the field values from in
    Value-Returned Column (optional). The default is the first column of the browse.
    In the Sort Columns field, enter the columns you want to have available for sorting. Enter the columns as a comma-delimited list of up to seven numbers. The first field name in the Selected Fields list is column 1, the second is column 2, and so on.
    The look-up browse sorts the records on the first column you enter in the Sort Columns field. The remaining columns you enter are listed in the selection list above the browse. Select another column in the list and the browse re-sorts on that column. When it re-sorts, the browse redisplays beginning at the first record. The browse does not redisplay beginning at the record that was selected when the re-sort was initiated. By default, the browse sorts on the first field in the Selected Fields selection list.
    Note: The Sort Columns field is enabled only for look-up browses.
    Press Go.

    Browse Maintenance, Browse Field Data
    Enter a sequence number to access field data.
    Identify the table and field and change the default field label and format (optional). To control the display length of a label, enter a Max Length value.
    Press End.

    Browse Maintenance, Revision History
    The program automatically creates a revision history line containing a revision number, the user name (or logon ID), and current date. You can modify this as needed. The revision history is also saved in the source code.
    Press Go to generate the browse. To save the browse data without generating the browse program press End.