SetEmptyStrToNull does not work correctly
Hi,
we have a problem with varchar fields, wich are not set to null even if we set SetEmptyStrToNull to true.
If the value of a field is an empty string it all works correctly, but if we have an fields with a string with only spaces, then the field value is set to an empty string (if TrimVarChar is true) but it is not set tu null.
Could you please check why the field is not set to null?
I attached a small sample demonstrating the behaviour. You only have to set correct parameters for connection and set a query text for any table with a varchar field.
Thanks in advance