Developer Studio 7.7.01: Validation Messages in Synonym Editor

By Maria Volant

Starting with Developer Studio 77.0.1, validation is performed when saving changes to a Master File in the Synonym Editor tool. Thus, if a Master File contains syntax that is either invalid or of restricted usage, a pop-up message is generated upon saving changes to the synonym in Synonym Editor.

The message, however, is simply a warning to alert you of what has been found wrong with the synonym, or to make you aware of any existing warning conditions. Should you decide to save the synonym, the changes are properly saved. Any requests executed against the synonym, assuming it does not contain invalid or unsupported syntax, should run fine.

For example, if you were to make any changes to the synonym shown on Screen 1, you would receive the validation message on Screen 2.

Screen 1

Screen 2

Clicking the OK button on Screen 2 would save the current changes made to the synonym. Clicking on the Cancel button would close the validation message and return you to Synonym Editor. Clicking the Details button would show the details outlined on Screen 3.

Screen 3

As you can see on Screen 3, the validation message is generated because the synonym contains fieldnames that are considered SQL reserved words. You could potentially experience problems working with SQL requests against synonyms that contain fieldnames that are SQL reserved words, so displaying the validation message can help you identify the problem when updating the synonym in Synonym Editor.

Again, runtime is not affected by this new behavior. The validation messages are displayed when saving changes to the synonym at design time in Synonym Editor, and are intended to alert you of a possible warning condition. They will not prevent you from saving the changes made to the synonym. In the next release, the information displayed in the pop-up box shown on Screen 2 will be modified to reflect that the message is simply a warning, and not necessarily an error or a failure.