I am using a TDBEdit for a string field of my DataSet. When the dataset is in edit mode, I change value of field string by deleting end spaces of the string. In the database, my string field type is VARCHAR2(19).
But when I post (and commit), spaces at the end of the string are still there !
When I set Debug property of dataset to True, I can see that my string field is not updated.

Why does string field seem to be trimed before verifying if it is necessary to be updated ?

How can I force my field to be flagged as a field to be updated ?

Thanks a lot.

Oracle 8.1.7, OCI 8.1, DOA 4.0.6, Delphi 7 Ent.

By default trailing spaces will be ignored by the dataset. You can set TOracleSession.Preferences.TrimStringFields to False to omit this.

Thanks a lot Marco !

It works as I want by modifying this property .
I've looked around StringField properties , DataSet properties , but not until OracleSession properties .

I was sure you got the answer...