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.com



  •     QAD Glossary

  • System Cross-Reference
    The System Cross-Reference function lets you identify how and where fields and tables are used.
    Using System Cross-References
    Explains how the System Cross-Reference (36.18) menu is used, includes information on the system’s background, and lists and describes the system’s table, field, and menu reports.
    Using Program Reports
    Lists and describes the program reports.
    Updating the Cross-Reference
    Gives step-by-step instructions on how to update cross-references.
    Using System Cross-References
    The System Cross-Reference menu (36.18) contains programs that identify how and where fields and tables are used within the system.
    System cross-reference activities can be customized to reflect your system setup. This lets you update cross-references when you add or change menu items. If you do not customize the system, you can use the cross-reference as it is.
    The cross-reference database requires about 50 MB of disk space, and consists of a set of reports summarizing database relationships such as:
    Which X and Y are used by this Z? X, Y, and Z can be tables, fields, menu items, or programs. Used can mean referenced, updated, or called.
    Which database tables are referenced or updated by this menu item?
    Which menu items call this field?
    Which program source files use this include file?
    You construct a cross-reference in two steps:
    1
    Compile the entire system.
    2
    Build a bill of material from the menu structure.
    The end result is a bill of material for each program, in which all programs called by the initial program are components, as well as fields called or updated by those programs.
    Cross-reference reports provide different ways of organizing the bill of material.
    Background
    The system consists of approximately 6200 programs that call some 10,000 fields. The programs consist of normal, executable Progress programs (.p files) and include files (.i files), which can be called from many different .p files.
    The menu system calls approximately 1400 of those 6200 programs. These called programs call numerous other .p and .i files. Progress programs can be nested, enabling you to place .i files within .i files, and so on.
    These Progress programs read or change information in database tables, such as the item master (pt_mstr) or the printer master (pr_mstr). The database tables consist of records containing entries in a group of fields.
    When Progress is compiled, the list of programs called and the tables and fields read or potentially updated by those programs can be output. This output, along with QAD-supplied utility information, is the source of the cross-reference.
    Table, Field, and Menu Reports
    The eight cross-reference reports answer such questions as “What does this table, field, message, menu item, or program do?” The syntax is XYZ. For example, the Tables/Fields by Menu Report tells you what tables X and/or fields Y are called by or updated by menu item Z. Similarly, Menu Item by Message Report tells you which menu items X/Y call a particular message Z.

    Table, Field, and Menu Reports
     
    Program Name
    Description
    Tables/Fields by Menu Report (36.18.1)
    Shows what tables or fields are referenced or updated by programs called by a top-level menu. Limit searches further by execution file, database table, and field. Report includes the type of actions performed by the selected programs on each table or field listed. Action types are create, search, update, delete, and access.
    Tables/Fields by Program Report (36.18.2)
    Similar to 36.18.1, but not limited to menu-level programs. Shows what tables or fields are referenced or updated by the named Progress program.
    Before running this report for a top-level program, first use Program Source File Report (36.18.16) to generate a list of subprograms called by the program. Then, run Tables/Fields by Program Report for each relevant subprogram.
    Menu Items by Field Report (36.18.4)
    Shows which menu items call a field or range of fields. Further limit searches by execution file and database table. Shows field name and table, calling menu item, and kind of action performed. Action types are create, search, update, delete, and access.
    Menu Items by Table Report (36.18.5)
    Similar to 36.18.4, but limited to a database table or range of tables, rather than fields. Shows which menu items call a table or range of tables. Further limit searches by execution file and menu item. Shows table name, menu item, execution file, and kind of action performed. Action types are create, search, update, delete, and access.
    Menu Items by Message Report (36.18.6)
    Shows which menu items call a particular message or range of messages. Further limit searches by menu and execution file. Shows message numbers and message text.
    Messages by Menu Item Report (36.18.8)
    Shows all the messages called by a particular menu item. Further limit searches by menu and execution file. Shows message numbers and message text.
    For all reports, the top-level selection is the first one searched. To speed up processing, enter values in the top level.