At 11:12 PM 16/09/2006, you wrote:

>I have noticed that replacing a. with the actual table name ie animal, and s
>with animalactivesire, still results in errors at design time, when you
>double click on IB_query, end activate the query, but is parsed correctly at
>runtime, thus not giving errors at runtime anymore.
>
>
>
>When using the Animal A, Animalactivesire s : causes errors at runtime and
>designtime.
>
>
>
>I'm sure there must be an error that creaped in with IBO code between FB1.53
>and FB2.
>
>
>
>I'm currently using IBObjects 4.6.Bc if only I knew where to start looking
>in the source code.
>
>It appears he is substituting the short form with the actual table name when
>creating the query in SQL.

The re-implementation of joins in IBO 4.6Bc, to accommodate aliases
in the SPB and the tighter identifier rules in Fb 2.0 is exhibiting a
number of bugs, unfortunately. For serious development, you'll need
to revert to 4.6B and Fb 1.5.3 until this gets resolved.

But do please feel free to prepare a test case demonstrating your
problem. It really will help.

Helen