Wolfgang,

Wolfgang Rohdewald schrieb:

> Hi,
>
> with 4.6Bc my TIB_Query generates a wrong statement when used with
> filter
>
> Filter := 'MA=''' + FMA + '''';
>
>
>
> the SQLQuery is:
>
> select
> kun.zentrale as zentrale, kun.filialeorzentrale, kun.sprache as sprache, kun.kurzname as filkurzname
> , MA
> , RL
> , MA.KUNDE as KUNDE
> , EBELEG
> from ma join kun on ma.kunde=kun.kunde
> order by kun.filialeorzentrale,kun.zentrale nulls first;

What kind of SQL is this???

I'm wondering it is valid at all.

What is MA, RL ???
A field _and_ a table?

Just curious...

Luc.