Covert filter inputs to uppercase so that mix case input will match an all caps DB setup.

Product Version

Property Value

Obj.FilterUcaseFunction = "Ucase function of the DB language"

QuickProp Keyword Abbreviation

Remarks

If you DB is setup as Ucase (Oracle). You have to write code in every application to UPcase the user input in filtering otherwise the filter SQL will fail. This property will save you all the trouble.

Example

• Obj.FilterUcaseFunction = "UCASE([[field]]"
• Obj.FilterUcaseFunction = "UPPER([[Field]])"
• Obj.FilterUcaseFunction = "UPPER(CAST([[Field]] AS varchar))"

See Also

z Class | Tornado Namespace | Special Topic - Filter

---