|
|
|
The Scripts panes in c-treeACE SQL Explorer and c-treeACE Explorer were removing spaces from the script in certain circumstances. If you ran a script with fields containing more than one consecutive space in a string, the actual values inserted had fewer spaces within the string. This occurred when the line did not end with a semicolon and it had more than one space character between words.
For example:
insert into trans_codes (rawtranscode, int_type, transcode)
values ('XX X X XXX', 28, 'XX X X XXX');
where:
The script has 3, 2, and 1 spaces between the Xs:
XX X X X
However, it was stored with only one space between the Xs:
XX X XX
The logic has been changed to correct this.
