Dynamically creating a query - using lexical parameters

From: <sivakumar_t_at_my-dejanews.com>
Date: Wed, 31 Mar 1999 01:20:26 GMT
Message-ID: <7drt8i$k50$1_at_nnrp1.dejanews.com>

Hi,

[Quoted] I dynamically created a query using lexical parameters

SELECT
&type1,
&type2

FROM &fromclause
WHERE &whereclause
GROUP BY &groupby

I have substituted values for these lexical references thru formula columns and the query now looks like

SELECT

t1.type1,
t2.type2,
t2.value

FROM tab1 t1,tab2 t2
WHERE tab1.type1 = tab2.type2
GROUP BY t2.type1,t2.type1,t2.value

However the problem is, When i run the report this query is not getting executed.Instead the relevant fields in the layout are having the text values.

For example,the groupby field in the layout has the value t2.typ1,t2.type2,t2.value.

(1) What should i do to run this report ? (2) I am dynamically changing the query and the groupby clauses.But my datamodel is going to be fixed.How Oracle Reports take care of this ??

Regards
Siva

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 03:20:26 CEST