Try this: Select "Type" from TableName "Type" is reserved word as I remember.
Regards, Paul > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Dan Cooperstock > Sent: Thursday, May 31, 2007 10:27 PM > To: firebird-net-provider@lists.sourceforge.net > Subject: [Firebird-net-provider] Short char field with longer name > returns padded > > I have a field in a table named Type, and declared as Char(1). What I'm > finding is that when I retrieve that column with a SELECT, the result > is > padded to the length of the field name (e.g. 4 chars, the length of > "Type"). > > This causes serious problems, for instance if I do "SELECT Type from > TableName" in a DataReader, then Load that into a DataTable, it throws > an > exception, because it figures out that the schema only allows for a > character length of 1 for the Type column, but the returned data is 4 > characters long. > > Is this a known bug? What can I do about it? I would rather not have to > rename my Type column to "T"! > > ----------------------------------------------------------------------- > -- > 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 ------------------------------------------------------------------------- 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
