From: "Ann W. Harrison" <aharrison@...>

> >> 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
> >>
> >> SQL error code = -206
> >> Column unknown
> >> SH_STOCKHOLDERID
> >> No message for error code 336397208 found.
> >>
> >>
> > Is the column name in mixed case? If so you will need to quote your
> > column names.
> >
>
> That's not exactly correct. If you defined the table like this

I think you both missed the point of the OP. The field name in the error
isn't even the same as the one in the query so where is it coming from? I
would assume there might be a field defined in one of the dataset properties
either as a persistent field or key link or something like that.