Are unions possible?

rbuser

Hi,

Is it possible to perform unions within the end-user facility (without
manual SQL modification)?

Alex

rbuser

Hi A Vasitch,

No.

regards,
Chris Ueberall;

rbuser

Do you think I should request this as a new end-user feature ie does it
sound like a useful feature to have?

Alex

digitalmetaphors

Unions in DADE are on the to-do list. The problem is that we have to support
all databases. Unions didn't make the cut already because not every database
supports it in the same way. We'd have to add more logic (per database
checks in our SQL generator) and generate different SQL.

For now you have to edit the SQL text in the query designer specific to your
database syntax.

Cheers,

Jim Bennett
Digital Metaphors