Selection out of range on RadComboBox.OnDataBinding

[Phil]

Hi:

I have just gone live on an application that ports data from a legacy system.  I am getting an exception on editing existing data.  Essentially, the case is different.  So, SQL is happy with the foreign key data, but the RadComboBox is not and causes an exception.  Any suggestions?

Phil

[Dimitar Terziev]

Hi Phil,

In order to troubleshoot this issue, please try to provide more information on your particular implementation that you are using.

My suggestion is to open a support ticket which will speed up the troubleshooting process.

All the best,
Dimitar Terziev
the Telerik team

[Phil]

I think a support ticket is a little excessive.  Do you have any suggestions?
Phil

[Dimitar Terziev]

Hello Phil,

The information provided in your previous post is insufficient in find the cause of your issue. Please try to provide me with the implementation of your combobox and the data base query used.

Regards,
Dimitar Terziev
the Telerik team

[Phil]

Hi:

The value in the foreign key table (combobox) is say:
HELLO
and the value in the table being updated is say:
Hello
The combobox is doing case sensitive lookup, so it causes a 'Selection out of range' exception.

Phil

[Dimitar Terziev]

Hello Phil,

What seems the solution to this issue is manually converting the value from the RadComboBox to lower case and then updating the table with the new value.

Best wishes,
Dimitar Terziev
the Telerik team

[Phil]

Hi:

try:

UPDATE primaryTable
   SET keyField = foreignKeyTable.keyField
  FROM foreignKeyTable
WHERE primaryTable.keyField = foreignKeyTable.keyField

[Dimitar Terziev]

Hello Phil,

Please refer to the following forum threads here and here where you could find a solution how to make both of the table column values lower case.

I hope this would help.

Kind regards,
Dimitar Terziev
the Telerik team