Oracle dataset TrimStringFields property

[mclot]

Sorry but I don't understand the behaviour of your Oracle dataset TrimStringFields property.
As you said in your help file, this property (set to 'True' by default) automatically removes trailing spaces when fetching rows from tables.
But if I insert a new row in a table (using a dataset, not a query), trailing spaces are not removed! The consequence is that if I try to use this trimmed value to load a field of another table, a foreign key constraint may fail because the original field contains i.e. 'XYZ ' while the fetched field is 'XYZ' !!!

Am I wrong? Any suggestion?

I don't understand your help statement "These trailing spaces usually just get in the way when modifying string fields, so this property is True by default": imho, this property should be False by default, considering the different behaviour when inserting and fetching a row.

Thanks

 

[Marco Kalter]

I guess it should also trim values entered in the fields. I have added this to the list of enhancement requests.

Note that if you want to use False as the default value for TrimStringFields, you can use the "Property Defaults" tool from the "Oracle" menu.