Hi, can anybody confirm such bug??? .net Provider 2.1.0.0 beta3 Create test table
CREATE TABLE TEST ( F1 INTEGER, F2 INTEGER ); ALTER TABLE TEST ADD CONSTRAINT UNQ1_TEST UNIQUE (F1, F2); Fill it with data INSERT INTO TEST (F1, F2) VALUES (1, 1); INSERT INTO TEST (F1, F2) VALUES (1, 2); INSERT INTO TEST (F1, F2) VALUES (1, 3); And now try to read the data with FbDataAdapter.Fill The Problem is - there will be created two different Unique Contraints for every column instead of one constraint with two columns and obviously you get the exception "cannot activate constraints". Is it a bug or missing functionality (or my stupidity :-) )? Can it be fixed (except the latter one :-D) ? -- View this message in context: http://www.nabble.com/Unique-Constraint-Bug-tf3637383.html#a10157152 Sent from the firebird-net-provider mailing list archive at Nabble.com. ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider