Query Does Not Reference a Table (QP0007)

Hi

In Designer I have created a GENERAL class which contains objects such as SYSDATE, NULL etc that I can use in conjunction with other objects.

Within my universe I have contexts. I have one class that is based on an isolated table (i.e. no joins) that does not form part of these contexts.

When I try to use an object from this isolated table in conjunction with one of my general objects, I get the QP0007 error.

I’m guessing that it is trying to generate 2 SQL statements and when it hits the general object (e.g. SYSDATE), it tries to generate a SQL statement which does not have a FROM TABLE clause in it.

Does anyone have a solution to my problem. :?

[moved to Designer forum - Andreas]


Grantie :uk: (BOB member since 2004-07-01)

Add the Dual table to your universe structure. Then open the Sysdate object, click on the Tables button, and select the Dual table. That should solve your issue. I’ve done this many times.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Thanks Michael. I created a join between DUAL and my isolated table which worked but seemed a bit of an overkill. This sounds much neater. I’ll give it a whirl tomorrow. :smiley:


Grantie :uk: (BOB member since 2004-07-01)