Re: Reports 3:Dynamic Query Fails When Tables Join Change From What It Initially Is In the User Parameter.

Hi Adam.

Best advice try to run it by hand first where you insert out parameters manually.
Then go to more advanced thinks like what your are trying to do. I am sure that you will find the problem on the way to the advanced solution.

Lars
5 years professional more than full time development. :))

In article <7gv4j0$iu9$1_at_newsin-1.starnet.net>,   "Adam Tadjkarimi" <adamt_at_hsl

td.com> wrote:
> I use a user parameter, :P_Dynamic, in one of the report SQLs as:
>
> SELECT &P_Dynamic
>
> And the initial value of this parameter is set to
>
> a.col_x col_x2, a.col_y col_y2 FROM tab_a a, tab_b WHERE
a.col_x=b.col_x
>
> This works fine as long as the initial value remains as is, but
depending on
> the user selection in the parameter form this can change in the
AFTERPFORM
> report trigger to:
>
> a.col_x col_x2, a.col_y col_y2 FROM tab_a a
>
> Once this happens it fails and I get the error message:
>
> ORA000904 invalid column name
> SELECT a.col_x col_x2, a.col_y col_y2 FROM tab_1 a
> WHERE (:col_x3 =col_x2)
>
> I should add that :col_x3 is the Datalink column from the parent
query.
>
> Any ideas why this is happening any hints to correct it or work
around?
>
> Thank,
> Adam Tadj
> Adamt_at_hsltd.com
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 14 1999 - 13:57:58 CEST