"DataTable.CaseSensitive" problem

  • Thread starter Thread starter MikeP
  • Start date Start date
M

MikeP

Hi there,

Can anyone explain why I should get the following error when creating a
"Relation" between two tables in Visual Studio:

"Cannot add a DataRelation or Constraint that has different Locale or
CaseSensitive settings between its parent and child table"

The "DataTable.CaseSensitive" property is the cause because it's on for one
table but not the other. The relation is a standard foreign key relation
between two integer keys however (there are no other relations) so I don't
see why this error should exist. I need the "CaseSensitive" property on for
one of these tables however but not the other since it effects searching via
"DataTable.Select()" for instance. Can anyone comment on this situation.
Thanks.
 
Back
Top