In the RDz803/FileMangerDB2 Criteria Editor, how to prevent the unexpectedly conversion of lower case data in the criteria into uppercase characters.
(see attached picture).
Many thanks to those who could give me the solution or a workaround.
This topic has been locked.
1 reply Latest Post - 2013-02-06T07:49:47Z by FrancoisLesage
Pinned topic RDz803, FileMangerDB2, Criteria Editor: lower case not supported ?
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-06T07:49:47Z at 2013-02-06T07:49:47Z by FrancoisLesage
FrancoisLesage 270003UDJ951 PostsACCEPTED ANSWER
Re: RDz803, FileMangerDB2, Criteria Editor: lower case not supported ?2013-02-06T07:49:47Z in response to FrancoisLesagehi,
I found the setting: even if it is a general setting you will not find it in the Preference menu.
While edit a template for a particular DB2 table: "DB2 Template Editor Options", hit "Options", uncheck "Uppercase input SQL statement". This will become the default for any DB2 table.