Hey Folks…
Just created a query that selected ITEM, UNIT_COST & QUANTITY from one table. When I added a column of DESCRIPTION from another table to the data provider, B.O. generated two queries. One for the ITEM, UNIT_COST & QUANTITY, then another query for the DESCRIPTION. There is a join on the ITEM column in both tables and all the contexts within the Universe have been resolved. Has any one seen this before? Thanks…
Michael Dempsey
Michael Dempsey
Data Base Administration
UNC Health Care System
919.966.4696
Are any of your objects defined as aggregate aware? We’ve had that happen when the aggregate levels were out of sync.
Michael Dempsey wrote:
Just created a query that selected ITEM, UNIT_COST & QUANTITY from one table. When I added a column of DESCRIPTION from another table to the data provider, B.O. generated two queries. One for the ITEM, UNIT_COST & QUANTITY, then another query for the DESCRIPTION. There is a join on the ITEM column in both tables and all the contexts within the Universe have been resolved. Has any one seen this before? Thanks…
Check to make sure that the two tables participate in the same context. This usually happens when tables are not in the same context. You may want to run an Integrity Check on your contexts.
Mike
At 02:59 PM 2/22/2000 -0500, you wrote:
Hey Folks…
Just created a query that selected ITEM, UNIT_COST & QUANTITY from one table. When I added a column of DESCRIPTION from another table to the data provider, B.O. generated two queries. One for the ITEM, UNIT_COST & QUANTITY, then another query for the DESCRIPTION. There is a join on the ITEM column in both tables and all the contexts within the Universe have been resolved. Has any one seen this before? Thanks…
Michael Dempsey
Michael Dempsey
Data Base Administration
UNC Health Care System
919.966.4696