Major Description
In the transformation editor, we should preserve any valid formatting created by the user, including:
i. Whitespace
ii. Tabs
iii. Spaces
iv. Capitalization
v. Name qualification (e.g. if they don't use fully-qualified names and it's not required for validation, then preserve it)
This is especially important for virtual procedure editing, though it should extend to any transformation editing. Currently, when a user validates their virtual procedure, we wipe out all these changes, which drives them crazy.
Even worse, if the procedure doesn't validate correctly, we remove our standard tabbed/spaced formatting, and the entire procedure becomes one gigantic string without carriage returns. This is very difficult to read, especially when working with any sizable procedure, and makes the debugging process nearly impossible. See screenshot.
Most users at Genentech that develop stored procedures are literally copying and pasting the procedure code back and forth between notepad and Designer to avoid this issue. This is a severe usability defect.
