Here's a bit more info: I just walked through the execution of "SELECT RECEIPT_TYPE FROM RECEIPT WHERE ..." in the debugger, and what happens is that it is still selecting 4 characters, e.g. "D ", when the column was declared as CHAR(1) and the real value should be "D". Obviously it ends up comparing that to the schema, seeing it's too long, and giving the error message I have quoted.
- Dan. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Cooperstock Sent: June 5, 2007 10:23 AM To: firebird-net-provider@lists.sourceforge.net Subject: Re: [Firebird-net-provider] Short char field with longer name OK, I have renamed the column (from TYPE to RECEIPT_TYPE) and I'm still getting the same error message when I do "select * from tablename": "Failed to enable constraints. One or more rows contain values violating non-null, unique or foreign-key constraints." However, I can execute the same SQL statement successfully in ISQL, which makes me think this is indeed a problem in the .NET provider. Any bright ideas? Thanks. ------------------------------------------------------------------------- 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
