mail-archives/mono-bugs/2006-February/039483.html

121 строка
4.9 KiB
HTML

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE> [Mono-bugs] [Bug 77630][Nor] New - Cannot remove a UniqueConstraint
if any ForeignKeyConstraint exists
</TITLE>
<LINK REL="Index" HREF="index.html" >
<LINK REL="made" HREF="mailto:mono-bugs%40lists.ximian.com?Subject=%5BMono-bugs%5D%20%5BBug%2077630%5D%5BNor%5D%20New%20-%20Cannot%20remove%20a%20UniqueConstraint%0A%09if%20any%20ForeignKeyConstraint%20exists&In-Reply-To=bug-77630%40chernobyl.ximian.com">
<META NAME="robots" CONTENT="index,nofollow">
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<LINK REL="Previous" HREF="039482.html">
<LINK REL="Next" HREF="039484.html">
</HEAD>
<BODY BGCOLOR="#ffffff">
<H1>[Mono-bugs] [Bug 77630][Nor] New - Cannot remove a UniqueConstraint
if any ForeignKeyConstraint exists</H1>
<B>bugzilla-daemon at bugzilla.ximian.com</B>
<A HREF="mailto:mono-bugs%40lists.ximian.com?Subject=%5BMono-bugs%5D%20%5BBug%2077630%5D%5BNor%5D%20New%20-%20Cannot%20remove%20a%20UniqueConstraint%0A%09if%20any%20ForeignKeyConstraint%20exists&In-Reply-To=bug-77630%40chernobyl.ximian.com"
TITLE="[Mono-bugs] [Bug 77630][Nor] New - Cannot remove a UniqueConstraint
if any ForeignKeyConstraint exists">bugzilla-daemon at bugzilla.ximian.com
</A><BR>
<I>Thu Feb 23 15:50:39 EST 2006</I>
<P><UL>
<LI>Previous message: <A HREF="039482.html">[Mono-bugs] [Bug 77530][Nor] Changed - [PATCH] serialization of
integral enum value is not correct
</A></li>
<LI>Next message: <A HREF="039484.html">[Mono-bugs] [Bug 77391][Nor] Changed - [PATCH] Small fixes for
zero-length targetNamespace
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#39483">[ date ]</a>
<a href="thread.html#39483">[ thread ]</a>
<a href="subject.html#39483">[ subject ]</a>
<a href="author.html#39483">[ author ]</a>
</LI>
</UL>
<HR>
<!--beginarticle-->
<PRE>Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.
Changed by <A HREF="http://lists.ximian.com/mailman/listinfo/mono-bugs">prensing at cimetrics.com.</A>
<A HREF="http://bugzilla.ximian.com/show_bug.cgi?id=77630">http://bugzilla.ximian.com/show_bug.cgi?id=77630</A>
--- shadow/77630 2006-02-23 15:50:39.000000000 -0500
+++ shadow/77630.tmp.4515 2006-02-23 15:50:39.000000000 -0500
@@ -0,0 +1,47 @@
+Bug#: 77630
+Product: Mono: Class Libraries
+Version: 1.1
+OS:
+OS Details:
+Status: NEW
+Resolution:
+Severity:
+Priority: Normal
+Component: Sys.Data
+AssignedTo: <A HREF="http://lists.ximian.com/mailman/listinfo/mono-bugs">tsenganal at novell.com</A>
+ReportedBy: <A HREF="http://lists.ximian.com/mailman/listinfo/mono-bugs">prensing at cimetrics.com</A>
+QAContact: <A HREF="http://lists.ximian.com/mailman/listinfo/mono-bugs">mono-bugs at ximian.com</A>
+TargetMilestone: ---
+URL:
+Cc:
+Summary: Cannot remove a UniqueConstraint if any ForeignKeyConstraint exists
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+When using a DataSet, I want to check that certain columns in one DataTable
+are unique. To do this, I create a UniqueConstraint and add it to the
+DataTable. I record any errors. I then want to remove the constraint. I do:
+ dataSet.dataTable.Constraints.Remove( &quot;constraintName&quot; );
+This always fails because it insists that I remove all the foreign key
+constraints first.
+
+Note that the constraint I am adding is not related to the FK constaints.
+It is probably reasonable to not allow UniqueConstraints to be remove if
+their columns are members of FKs, but this is not the case.
+
+Steps to reproduce the problem:
+1. Create a data set with a FK relation
+2. Add a UniqueConstraint on some column(s) which are not in the FK
+3. Try to remove it.
+
+Actual Results:
+Complains that you need to remove the FK constraint first
+
+Expected Results:
+Removes constraint.
+
+How often does this happen?
+Always.
+
+Additional Information:
</PRE>
<!--endarticle-->
<HR>
<P><UL>
<!--threads-->
<LI>Previous message: <A HREF="039482.html">[Mono-bugs] [Bug 77530][Nor] Changed - [PATCH] serialization of
integral enum value is not correct
</A></li>
<LI>Next message: <A HREF="039484.html">[Mono-bugs] [Bug 77391][Nor] Changed - [PATCH] Small fixes for
zero-length targetNamespace
</A></li>
<LI> <B>Messages sorted by:</B>
<a href="date.html#39483">[ date ]</a>
<a href="thread.html#39483">[ thread ]</a>
<a href="subject.html#39483">[ subject ]</a>
<a href="author.html#39483">[ author ]</a>
</LI>
</UL>
<hr>
<a href="http://lists.ximian.com/mailman/listinfo/mono-bugs">More information about the mono-bugs
mailing list</a><br>
</body></html>