Subject Re: [firebird-support] Re: Column unknown error
Author Ann W. Harrison
woody-tmw@... wrote:
> 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.
>>>>
>
> 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.
>


Sorry. Right. How is sh_Name1 defined?


Best,


Ann