I just looked it up, and you are right. It is a reserved word. However, 
that doesn't exactly explain why "Select Type from TableName" does work, 
except for always returning 4 characters instead of 1. It returns the 
correct data from the field (one character), just padded with 3 spaces on 
the right.

I guess regardless of the answer to this question, I am going to have to 
change the name of the field. Thanks.

[EMAIL PROTECTED] ("Mercea Paul") wrote :

> Try this:
> Select "Type" from TableName
> 
> "Type" is reserved word as I remember.
> 
> Regards,
> Paul
> 

-------------------------------------------------------------------------
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