[Solved] Union query alternatives
Posted: Tue Aug 20, 2019 6:47 am
Hi,
Having a bit of a problem either with my logic and or putting multiple query outputs into a union query and sort the result of the union by a date field.
Previously the union based on queries worked as none contained calcs, listed all but dates unsorted for the union but sorted as per individual source query.
Now the input querys contain dateadd and datediff calcs, the datatypes and sequence of fields is identical, however the calcs per query are not identical and
I get the 'only quries are allowed error'.
One alternative way I can think of is to to a maketable query and then append the output of all the input queries, however that seems to be pretty elaborate as it would
require constant deletes and re append.
Any ideas ?
Attached a screendump - another possibility might be to hide the column headings in the tablecontrol, but there does not seem to a property to do this.
Thanks for your thoughts or ideas
Having a bit of a problem either with my logic and or putting multiple query outputs into a union query and sort the result of the union by a date field.
Previously the union based on queries worked as none contained calcs, listed all but dates unsorted for the union but sorted as per individual source query.
Now the input querys contain dateadd and datediff calcs, the datatypes and sequence of fields is identical, however the calcs per query are not identical and
I get the 'only quries are allowed error'.
One alternative way I can think of is to to a maketable query and then append the output of all the input queries, however that seems to be pretty elaborate as it would
require constant deletes and re append.
Any ideas ?
Attached a screendump - another possibility might be to hide the column headings in the tablecontrol, but there does not seem to a property to do this.
Thanks for your thoughts or ideas