At 07:12 PM 24/04/2007, you wrote: >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);
I don't see you commit the DDL before attempting to apply DML to the table. Always do that, or you will get the corrupted effects you describe. Helen ------------------------------------------------------------------------- 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
