C# Cascade Update doesn't work if only change is case of a letter

's Computer Specifications

I am using the .NET Framework 1.1 and C#. I have a dataset with several
tables in it and several relationships between tables. I have the same
problem with each relationship. They were created as follows: I have
created a DataRelation between 2 tables. A ForeignKeyConstraint is made for
the DataRelation and the Delete and Update rules both set to Cascade.
Everything works as expected unless the only change to a key is the case of
the characters. For example if I change SomeName to somename, the change
does not cascade to the other table. The relationships are case sensitive so
the rows affected now lose the ability to follow the relationship.
This seems to be a bug. Is there a patch available? In some cases I can
use brute force to overcome this but there are so many handlers on changes
that this gets complicated.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
App window will not Restore to size. Cascade doesn't work either	JB	Windows XP Help	4	19th Feb 2009 07:02 PM
Using Autonumber as PK, cascade update doesn't work?	=?Utf-8?B?S2V2aW5OR0M=?=	Microsoft Access Database Table Design	17	3rd Nov 2008 12:23 AM
Upper case letter change to lower case when opened on another comp	Kleesg	Microsoft Powerpoint	1	24th Oct 2008 10:17 PM
Change the text from lower case to upper case in an Excel work boo	=?Utf-8?B?ZGF2ZTAxOTY4?=	Microsoft Excel Misc	2	9th Dec 2005 09:09 AM
Combo box cascade doesn't view record after update	=?Utf-8?B?RGVraQ==?=	Microsoft Access Form Coding	0	13th Jul 2005 10:43 PM