Re: two blocks referring same table??

From: Jan Schaefer <jan.schaefer_at_kksl.uni-leipzig.de>
Date: Fri, 08 Aug 2003 08:52:11 +0200
Message-ID: <bgvhba$ptf$1_at_news.uni-leipzig.de>

Manikandan schrieb:
> Hi,
> I am using Oracle Forms 6i.
> I have 2 blocks BLOCK1 and BLOCK2 referring a single table.
> Whenever I get
>
> multiple rows in BLOCK2, the rows in the BLOCK1 are also repeated.
> The sample list as follows:
> BLOCK1 columns BLOCK2 columns
> LRTP34000C LRTP11000C
> LRTP34000C LRTP22000C
> LRTP34000C LRTP34000C
> LRTP34000C LRTP34000D
> LRTP34000C LRTP34132C
> I need to have only the distinct rows in BLOCK1.
> Can anyone help me, Please?

Can you give us more details about your blocks? What is the DEFAULT_WHERE clause? Are the blocks connected with a relation? With the given informations it's hard to help you...

So long,

Jan Received on Fri Aug 08 2003 - 08:52:11 CEST

This message: [ Message body ]
Next message: Andy Smetana: "Displaying groups in arbitrary order"
Previous message: Keld Nielsen: "Re: newbie question"
In reply to: Manikandan: "two blocks referring same table??"
In reply to Manikandan: "two blocks referring same table??"
Next in thread: Daniel Morgan: "Re: Plot Graph in Oracle Form?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message