This is a migrated thread and some comments may be shown as answers.

Error Message in "Edit Table" window caused by unsupported SQL type

3 Answers 51 Views
Design Time (Visual Designer & Tools)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Skywalker
Top achievements
Rank 1
Skywalker asked on 25 Jan 2011, 11:52 PM
Hi,

There seems to be a bug in the Visual Designer that causes an error message when I want to edit a table: "System.ArgumentException: DataGridViewComboBoxCell value is not valid."
I suspect this is because my database table contains a column with the XML sql type, which I guess is not supported by the ORM visual designer.
When I try to change the SQL type from within the ORM Visual Designer / Edit table dialog, I continuously receive the error message box.

Please find attached a screenshot of the situation. For now I'll have to kill the Visual Studio process because the error popups each time the SQL type comboboxcell receives the focus ( and I'm not fast enough to remove the focus after closing the error message box).

Regards,

Skywalker

3 Answers, 1 is accepted

Sort by
0
Skywalker
Top achievements
Rank 1
answered on 26 Jan 2011, 12:06 AM
I changed the datatype from XML to NVARCHAR by hand-editing the .rlinq file and now the error is resolved (since NVARCHAR does exist in the SQL type combobox).

Since the XML type doesn;t seem to be supported I will go with BINARY for now, although it would definitely be cool if I could use XML. Any chancethe XML datatype will be supported in a future version of OA?
0
Accepted
Damyan Bogoev
Telerik team
answered on 26 Jan 2011, 03:43 PM
Hello Skywalker,

In the Table Editor, the SQL types combo box is bound to a collection of database specific types. The Xml MSSQL data type is not part of this collection which leads to the error. This is a known issue which is already fixed and the fix is part of the latest internal build - 2010.1306.  You could download it under your account.
Hope that helps.

Kind regards,
Damyan Bogoev
the Telerik team
Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
0
Skywalker
Top achievements
Rank 1
answered on 27 Jan 2011, 10:36 PM
Hi Damyan,

Excellent, that worked!

Thanks!
Tags
Design Time (Visual Designer & Tools)
Asked by
Skywalker
Top achievements
Rank 1
Answers by
Skywalker
Top achievements
Rank 1
Damyan Bogoev
Telerik team
Share this question
or