Page 1 of 1
changing parameter value at run time
Posted: Mon May 14, 2007 2:50 am
by nadia
hi
i have a problem and i need some help. i'm trying to change the value of a field at excution time ,the problem is that i have two queries without any link between them and i want to change data the second query due to the data in the first query.
with regards
Posted: Mon May 14, 2007 3:01 am
by ahmadbilal
please Elaborate your problem. are you facing this problem in oracle forms or oracle reports.
Posted: Mon May 14, 2007 4:12 am
by nadia
Thanks for your attention,
i'm facing this problem in oracle reports.
Posted: Mon May 14, 2007 4:44 am
by ahmadbilal
Please check lexical parameters to pass runtime value
Posted: Mon May 14, 2007 5:08 am
by nadia
i don't have porblem in lexical parameter.
my problem is like this:
in group1 i passed a lexical parameter but in group2 i have a tree with no data link to group1, for example group1 contains depts and group2 contains emps but there aren't any data link and i want to appear for each dept it's emps as a hirechytree
Posted: Mon May 14, 2007 5:33 am
by ahmadbilal
please post your exiting query.
Is there any primary foreign relation between emp and dept table if so then apply lexical parameters to pass parameters at runtime.
if you have no relation between these tables then noways to join this data.
Posted: Thu May 24, 2007 6:08 am
by abdul_S
did your problem resolved or not yet