Method Compare

Use the Method Compare modal form to view and compare two versions of a method's code. Typically, this means comparing the original base version with a modified version. You can make changes to the modified version and then merge the changes to create a new version.

This form can be accessed either by clicking Compare w/ Base on the Edit Stored Procedure form; or by clicking Edit Stored Procedure on the EXTGEN Listing form.

When this form opens, the two versions of the method's code display in separate panels side-by-side. The base version of the stored procedure method displays in the left panel, and the modified (extgen_) version displays in the right panel. Any differences between the two versions display in red in the base verson.

To move between and select blocks of differing (highlighted) code in the base version, use the Next Diff and Previous Diff buttons.

To perform a one-way merge of any blocks of code that exist in the base version but not in the extended version, use the "Merge" button, which is a very small gray button that displays at the far left of the first line of a highlighted base code block. When you click this button, that block of the base code is merged into the extgen_ code.

To make further, manual changes to the extgen_ version, double-click inside the right panel and edit the code as needed.

Note: You cannot actively and iteratively test your code in this workspace. We recommend that you test your code in a local SQL test environment before submitting it to the database.

To return the merged and edited code to the Edit Stored Procedure form, click OK.