Problem in Search Help

[Former Member]

Hi,

I have a small problem in using search help, can you please help me out!!!

Here my requirement is:

I have to get the entries from a Text Table based on the "Description".

In search help, I have placed "DESCRIPTION" as my input parameter. and When the user enters description in that, it gets the entries from text table.

Ex. He can give it as : AIR* or Air* or aIR*. Based on this input I need to get the entries from text table.

But the problem is, in Text table, The entries are case sensitive. Because it the field has DOMAIN: TEXT200 which is case sensitive.

I hope you understood my requirement.

Could you please help me out, how can I make my requirement done.

Thanks,

Sandeep

[Former Member]

Hi Sandeep,

you can change your table field from text200 to char200 or you have to compare both input and table field after conversion to upper case in your search help to get the right information.

Regards,

Klaus

[Former Member]

Hi,

In the Search Help, Tick the Check Box (Modified Column) with respective to the Description Filed. This will enables you to create your own Data Element.

You can remove the Check box of Case Sensitive and assign that Data Element in Search Help.

Rgds,

Shyam

[Former Member]

Hi,

validate the decription entered by the user. first check the case. if it is in lower case try to convert it in to uppper case. then reteive the values from the text table based on the converted text. hope you got a point.

Regards,

Kiran