When designing a form, one of our requirements is to allow the end user to enter text such as "Police Uniform" for a description.  However if the user types "Police Uniform    " (spaces), we want to trim the field.  So I turn on Trim Right in the BO.  Now I cannot type a space after the letter "e" in police. 

So I was advised to change the BindingUpdateMode to "OnValidation".  Now when I add a new record, type in a description like above, the description is NOT saved and is blank in the database and is displayed as blank on the UI form!

What gives?

Ben

I think what Greg is saying, instead of doing the Trim'ing the way StrataFrame currently does it, why not add code to the .Designer file automatically that will .Trim each field correctly before saving the entry (Insert, Update) based on the Trim setting in the Business Object Mapper?

Ben

Yep, that is what I'm saying.



Why not just add an event handler automatically to handle the CheckRulesOnCurrentRow in the designer? The user could have another handler. They would just have to be clear that trimmed fields might or might not yet be trimmed.

Trent,

You are correct.  I cannot type something like "Police Officer" because the BO keeps trimming the space much like setting it up via the Business Object Mapper.

So what do you suggest?  Here is what I want:

User types "Police Man    " (trailing spaces)

We automatically trim the field to "Police Man"

Ideas?

Ben

You're wanting an automated solution for something that will take some engineering.  This will have to be done at the BO level or require a change to the textbox control.  You can create your own textbox by inheriting the StrataFrame textbox.  In the Validating event you could manage this.  (I would recommend having a property to determine whether or not to do anything.