topic Re: Data fetch from table in Application Development and Automation Discussions

Data fetch from table

Karan_Chopra_ — Mon, 04 Feb 2008 09:08:39 GMT

i have to select data from a database table into internal table but i want that it shud be selected as it is means i have a char 30 field which may have CAPS and small values in table but in the internal table it comes as all CAPS but it shud come as it is e.g "Data" shud come as "Data" in internal table but it comes as "DATA".

Re: Data fetch from table

Former Member — Mon, 04 Feb 2008 09:12:51 GMT

send ur code..

Re: Data fetch from table

Former Member — Mon, 04 Feb 2008 09:13:07 GMT

Just check the Domain of the concerned field. There will be a characteristic check box called "lower case" in the Definition tab of your domain. See if that is Flagged. If that is flagged, then the stored record will be case sensitive. In best practice, you should not have that flagged, So that the records will not be case sensitive and you will not have to face a similar situation.

Hope this helps.