EXTGEN Listing

This column displays the row number of each extended stored procedure.

This column displays an icon summary of the state of each extended stored procedure in the system:

• Red: This indicates that no base version of the stored procedure method exists.

  This typically means that Infor has removed the base stored procedure for some reason, but the customer still has an extended stored procedure version. It might also mean that some other party has "coded out" the stored procedure with a custom assembly extension class for this stored procedure.

  If that is the case, we recommend that you look in release notes and/or the help, to discover why the base stored procedure was removed. If that is not fruitful, we recommend that you contact your Support Representative for assistance.

• Yellow: This indicates that the base stored procedure still exists, and that no custom assembly extension class for this stored procedure exists. However, the Modify Date of the base stored procedure is newer than the Modify Date of the extended stored procedure.

  In a case like this, the code in the base stored procedure should be reviewed using the Compare w/ Base option on the Edit Stored Procedure form. Then, if you are comfortable with programming, you can merge and resubmit the extended stored procedure code. If not, we recommend that you reach out to your Support Representative for assistance.

• Green: The base stored procedure has NOT been removed; no custom assembly extension class exists for this stored procedure; and the Modify Date of the base stored method is NOT newer than the Modify Date of the extended stored procedure.

  In this case, there is likely no action required. If you want, you could use the Compare w/ Base option, but it is unlikely that any changes would be required for a merge action.

This column displays the name of the extended stored procedure.

This column displays the date on which the extended stored procedure was last modified.

This column displays the name of the base stored procedure on which the extended stored procedure is based (and which it has modified).

This column displays the date on which the base stored procedure was last modified.

This column displays a brief verbal description of the current state of the extended stored procedure.

This field displays the same information as the column of the same name in the top section.

The read-only field to the right of the View button displays the name of the extended stored procedure.

To view and optionally edit the extended stored procedure code, click View. When clicked, the extgen_ code displays in the Edit field in the middle of the bottom section.

This read-only field displays the date that the extended stored procedure was last modified.

This read-only field to the right of the second View button displays the name of the base stored procedure, if any, that the extended stored procedure extends.

To view the code for the base stored procedure, click View. When clicked, the base code displays in the Edit field in the middle of the bottom section.

This read-only field displays the date that the base stored procedure, if any, was last modified.

This read-only field displays the code for the selected extended stored procedure as it currently exists in the database.

This button launches the Edit Stored Procedure form as a modal form populated with the data/information of the selected EXTGEN method. You can then use that form to modify the code and resubmit it as the new version of the EXTGEN method.

This read-only field displays the code for the extended stored procedure (top panel), the code for the base stored procedure (bottom panel), or both. This code displays only after you click one or both of the View buttons.