Subject | Re: [firebird-support] Re: Column unknown error |
---|---|
Author | Ann W. Harrison |
Post date | 2007-01-29T17:00:44Z |
woody-tmw@... wrote:
Best,
Ann
> From: "Ann W. Harrison" <aharrison@...>Sorry. Right. How is sh_Name1 defined?
>>>> 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.
>
Best,
Ann