I am working with MS sql 2008 ( and above ) with pb12.5 ( and now will be 2017 ) classic , Windows 7 , 10 (64 bit , 32 bit machines
Why the datawindow is saved to the data base with the max length for each field full with spaces ?
Even if i put NULL for all fields every time i opened a new row for each dw
It happens only for string type fields
This is unlike Sybase Sql Anywhere where the data was saved only what the user wrote in the the dw fields
that forces me to review all dw and put the Trim() function to all computed fields which uses string type fields
There is a way to solve it