--- In firebird-support@yahoogroups.com, "Mark Kress" <mkress33@...>
wrote:

>
> I'm using version 2.01 and .Net
>
> If I do the following query I can return a dataset without error.
> SELECT * FROM STOCKHOLDERS
>
> If I do the following query I get an error trying to return a
> dataset. (sh_Name1 is a valid column in the STOCKHOLDERS table)
> SELECT sh_Name1 FROM STOCKHOLDERS
>
> Here is the error:
>
> Dynamic SQL Error
> SQL error code = -206
> Column unknown
> SH_STOCKHOLDERID
> No message for error code 336397208 found.
>
> Any help would be greatly appreciated.
>
> Thanks
> Mark
>

Is the column name in mixed case? If so you will need to quote your
column names.

Mick