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
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
