Using UPPER and PROPER functions

[Ted_Berry]

Hello,

I am evaluating in.de and am having trouble converting a field to UPPER case or PROPER case. The database is an existing MySQL 5 database. The field in question is varchar(50) named category.category. (Table and field name)

I cannot find the correct event to place the code using (x)Upper. I have tried add before inert and add after insert, but it does not work. I do not get any compilation errors or anything, but the data remains unchanged.

Could you please explain how to use this?

Thank you,

Ted Berry

[g.lanzi]

If you want to force the upper case in a certain database field you can use a Visual Style with mask ">", so that the user will see the uppered string while typing too.

You can find additional information about the Visual Style's Mask in the Chapter 4.8.1 of the user's guide.

Is that what you were looking for?

[Ted_Berry]

Hello Giuseppe,

Yes, this is what I was looking for. Thank you very much. I clearly missed it in the documentation. Excellent product and great support!

Thank you,

Ted Berry