I'm creating a very basic report where I do a union on two queries from the same source but different filters.  When I try to do a union between them I get the following error:

RQP-DEF-0537 SubQuery 'Query1' used in a set operation cannot use members or member functions.

Is this something that's just not allowed?  I double-checked that the column are of the same type and there are no custom fields.  I have no issues when using a DataModule/Dataset.

Cesar

I'm creating a very basic report where I do a union on two queries from the same source but different filters.  When I try to do a union between them I get the following error:

RQP-DEF-0537 SubQuery 'Query1' used in a set operation cannot use members or member functions.

Is this something that's just not allowed?  I double-checked that the column are of the same type and there are no custom fields.  I have no issues when using a DataModule/Dataset.

Cesar

Hank, Is it possible to create a union between two uploaded files in a data module?  I have two simple upload files that have the same structure with just different data values in each.  I can easily create a report which has a union of two files and shows the resulting union data.  I would like to do that in a data module and thought that I could create a Table using SQL in my data module.  Unfortunately I can't seem to do that.  Bottom line is I want to be able to leverage the union of the two uploads across the CA platform not by just creating a report with the union.  Is this at all possible or is the idea of using the functionality in a data module to do that not appropriate or possible with uploaded files.  Thanks.

I'm creating a very basic report where I do a union on two queries from the same source but different filters.  When I try to do a union between them I get the following error:

RQP-DEF-0537 SubQuery 'Query1' used in a set operation cannot use members or member functions.

Is this something that's just not allowed?  I double-checked that the column are of the same type and there are no custom fields.  I have no issues when using a DataModule/Dataset.

Cesar

Hank, Is it possible to create a union between two uploaded files in a data module?  I have two simple upload files that have the same structure with just different data values in each.  I can easily create a report which has a union of two files and shows the resulting union data.  I would like to do that in a data module and thought that I could create a Table using SQL in my data module.  Unfortunately I can't seem to do that.  Bottom line is I want to be able to leverage the union of the two uploads across the CA platform not by just creating a report with the union.  Is this at all possible or is the idea of using the functionality in a data module to do that not appropriate or possible with uploaded files.  Thanks.

I'm creating a very basic report where I do a union on two queries from the same source but different filters.  When I try to do a union between them I get the following error:

RQP-DEF-0537 SubQuery 'Query1' used in a set operation cannot use members or member functions.

Is this something that's just not allowed?  I double-checked that the column are of the same type and there are no custom fields.  I have no issues when using a DataModule/Dataset.

Cesar

I'm creating a very basic report where I do a union on two queries from the same source but different filters.  When I try to do a union between them I get the following error:

RQP-DEF-0537 SubQuery 'Query1' used in a set operation cannot use members or member functions.

Is this something that's just not allowed?  I double-checked that the column are of the same type and there are no custom fields.  I have no issues when using a DataModule/Dataset.

Cesar

I'm creating a very basic report where I do a union on two queries from the same source but different filters.  When I try to do a union between them I get the following error:

RQP-DEF-0537 SubQuery 'Query1' used in a set operation cannot use members or member functions.

Is this something that's just not allowed?  I double-checked that the column are of the same type and there are no custom fields.  I have no issues when using a DataModule/Dataset.

Cesar