Subject Re: [IBO] filter on TIB_QUERY generates wrong SQL
Author Wolfgang Rohdewald
On Friday 29 December 2006 19:01, Lucas Franzen wrote:
> What kind of SQL is this???
>
> I'm wondering it is valid at all.
>
> What is MA, RL ???
> A field _and_ a table?

yes. Is that a problem? I always try to use the table name for the primary key field.
I seem to remember that this is even recommended somewhere in the IBObjects documentation.

This query works fine with 1.5.3, and also with IBO (after adding that where 1=1)

--
Wolfgang