case sensitve

[Former Member]

Hi All,

I am retriveing the data from database tables.

there some records in uppercase and some records in lower case when i give value in selection screen in upper case it is retriveing the for only upper case but it has to ignore the case.

Please any one give me the solution for this.

Thanks in Advance.

Thanks&Regards.

Ramu.

[Former Member]

Hi All,

I am retriveing the data from database tables.

there some records in uppercase and some records in lower case when i give value in selection screen in upper case it is retriveing the for only upper case but it has to ignore the case.

Please any one give me the solution for this.

Thanks in Advance.

Thanks&Regards.

Ramu.

[venkata_ramisetti]

Hi,

Looks like you are using field that contains data element with type CHAR type and property in Domain Lower case = blank.

Use the parameter loike below type..

PARAMETER: P_TEXT TYPE TEXT100.

You can use builtin data elements Text100, Text 200, TEXT256..etc for texts .

Thanks,

Ramakrishna

Message was edited by: Ramakrishna Prasad Ramisetti

[Former Member]

Hi Ramu,

In the Field check at the DOMAIN -> Definition level

whether the field is marked LOWER CASE.

If this flag is set, upper case and lower case are distinguished when you enter values with screen masks.

Otherwise all the letters entered will be converted to upper case when you enter values with a screen mask.

So while reading the table you:

case 1 - Translate to Upper case and read the table.

if this fails.

case 2 - Translate to lower case and read the table.

if both fails, then only throw the error message.

Reward Points if this helps.

Manish

Message was edited by: Manish Kumar

[Former Member]

hi Ramu,

Declare the parameter of database field type ...

REgards,

Santosh

[Former Member]

U can do is define a range for the particular field.

Populate the range with upper case value(enter via selection screen).

Translate the screen values to lower case.

Append the data to range.

If you use the range as the selection criteria, it would fetch both upper and lower case data.

[Former Member]

Hi,

U may translate in lower case or vice-versa .

eg. TRANSLATE c TO LOWER CASE.

if helpful pl reward.

Cheers.

[Former Member]

There are two solutions:

The first (and easiest) is to check to see if there is another similar field in the table that has the same data but in upper case. If there is one, use it.

If there is no such field, you can use native SQL to do this.

Rob