I'm creating a Mail Merge Template Spread sheet.
After creating the two queries I need to setup the relationship.
Using the Master-Detail Relation Editor (Manage Relations Button) I setup to my two fields from the two different tables.
When I click OK I receive the following error:
Cannot set relation between columns XXXX of type sytem.Int32 and YYYY of type system.UInt32.
I understand they of different column types but they really only contain integer values. When I run this type of join in normal sql statement our database engine does not complain about it. You should be able to setup relationships with mix matched column types Int16, Int32, Int64 and UInt… ect. Let the DB engine decided if there is a problem, most the times it does not care, its looking at it as a value, not a column type.
My recommendation would be for you to remove this error preventing me and my users to continue with the Join. Let the database engine reject it if necessary. It's ok for it warn me, but not ok to prevent it from continuing, because as it stands now I cannot use it.
Thanks
Hi Mike,
Thank you for the detailed description.
That exception is thrown by our source code and having examined your thoughts, I wouldn't say that I'm not agree with your point of view. It seems that it's worth displaying a warning message in such situations rather than throwing an exception and preventing the SqlDataSource from being filled with data at all, in case it is possible to convert, for example, the aforementioned column types to each other.
I have passed this thread to our R&D team to determine if we can improve this situation and implement the changes in the suggested way. Please stay tuned for further updates in this thread and thank you for your cooperation.