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

Reply via email to