Some info about if condition and case sensitive

[Former Member]

               hi..

                i am doing this one in my code..

              here a67 is a variable type string.

                it is comming from the screen.. CFL item code...

               my requirement is

if user choose A00006 THIS CONDITION WILL BE EXECUTED.

but if he type.. a00006 this is condition will not execute..

is there any statement or operation it will be converted into automatically to capital letters..

give me your valuable suggestions....

                            If (a67 = "A00006") Then

                                Dim ds5 As SAPbobsCOM.Recordset

                                ds5 = ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

                                ds5.DoQuery("select t0.code from ostc t0 where t0.name='VAT @ 4%'")

                                omatrix.Columns.Item("V_8").Cells.Item(pVal.Row).Specific.value = ds5.Fields.Item(0).Value

                              end if

[KennedyT21 · Accepted solution]

Hi Seenu,

Use TOUpper

                            If (a67.ToUpper() = "A00006") Then

                                Dim ds5 As SAPbobsCOM.Recordset

                                ds5 = ocompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)

                                ds5.DoQuery("select t0.code from ostc t0 where t0.name='VAT @ 4%'")

                                omatrix.Columns.Item("V_8").Cells.Item(pVal.Row).Specific.value = ds5.Fields.Item(0).Value

                              end if

Regards

Kennedy

[Former Member · Accepted solution]

Thank u very much Working Good....

Keep Posting....

[Former Member]

Hi,

    Use   If (a67.ToUpper() = "A00006".ToUpper())

With regards,

Venki .A