Could someone please guide me as to which event (forms or control) in particular should I utilize if I would want to make corrections to string entered into a textbox in a grid control?
For instance: if someone types “john smith”, I’d like to be able to submit that entry into the database as “John Smith” instead.
My guess was BeforeRecordAction in the form environment or TextModified in the textbox control would be appropriate contenders, but I’m not having much luck with either.
With respect to the BeforeRecordAction event, I know it fires up twice, once on behalf of the XFormComponent interface and the second time from XFormController. I tried all kinds of different approaches, with no positive outcome. The TextModified did not render any promissing outcome. Are these events meant for a different purpose, or am I simply doing something wrong?
I’m using mysql and I know I could easily have done it on the server side with stored procedures and triggers, but I wanted to experiment further with LO. Any advice would be greatly appreciated.