Don't update string field

cadotp

Member
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 :cool: .
I've looked around StringField properties :eek: , DataSet properties :eek: , but not until OracleSession properties :confused: .

I was sure you got the answer... ;)
 
Back
Top