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

4 posts, 1 answers
  1. Skywalker
    Skywalker avatar
    67 posts
    Member since:
    Sep 2007

    Posted 25 Jan 2011 Link to this post

    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
  2. Skywalker
    Skywalker avatar
    67 posts
    Member since:
    Sep 2007

    Posted 25 Jan 2011 Link to this post

    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?
  3. DevCraft banner
  4. Answer
    Damyan Bogoev
    Admin
    Damyan Bogoev avatar
    581 posts

    Posted 26 Jan 2011 Link to this post

    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.
  5. Skywalker
    Skywalker avatar
    67 posts
    Member since:
    Sep 2007

    Posted 27 Jan 2011 Link to this post

    Hi Damyan,

    Excellent, that worked!

    Thanks!
Back to Top