Config Builder Hotfix - Carriage Return Issue

There is an issue in Config Builder versions 2.2.1 - 2.2.4 when directly trying to edit SQL in a configuration grid cell, data loss could possibly occur.

The root of this issue is due to the Excel based Config Grids do not support carriage returns in a cell.  When a carriage return is detected, is simply ignores all statements beyond the carriage return.

For example, in the following statement:

select count(*) 
from table1

Only the   select count(*)   will be displayed.  This is a non issue when the cell is in read mode.  However, if the cell is edited directly in the sheet (not using the rich text content viewer), since it does not support the full statement beyond the carriage return, all subsequent data lines could be lost. In this example, from table1

This has been solved in the Config Builder 2.2.5.  The Config Builder 2.2.5 will delimit all carriage returns with a ¶ symbol (asii chr 182).  This can be installed standalone onto of 124, 125 and 126 pack.