> -----Original Message-----
> From: Helmut Steinberger [mailto:hs@...]
> Sent: Viernes 12 de Enero de 2001 15:04
>
> This does not work like I expect it to work. I think it will be
> transfered to:
> select field1 as number, field2 as name from table1
> union
> select field1, field2 from table2
> where field1 > 10
>
> This results in that only the data of the table2 is restricted and all
> data from table1 is fetched.

If you know the fields in advance and only have to build the WHERE part
dynamically, create a VIEW and select from it.

> BTW annother question:
> For debugging cases like this, it would be very helpful, to have a
> look at the sql statement sent to the interbase server by IBO.

See TIB_Monitor and TIB_MonitorDialog. They do that.

C.