Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!news2.euro.net!newsfeed.freenet.de!news-lei1.dfn.de!news.uni-leipzig.de!not-for-mail
From: Jan Schaefer <jan.schaefer@kksl.uni-leipzig.de>
Newsgroups: comp.databases.oracle.tools
Subject: Re: two blocks referring same table??
Date: Fri, 08 Aug 2003 08:52:11 +0200
Organization: Uni Leipzig
Lines: 25
Message-ID: <bgvhba$ptf$1@news.uni-leipzig.de>
References: <3212284.1060257283@dbforums.com>
NNTP-Posting-Host: percy.imise.uni-leipzig.de
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-leipzig.de 1060325546 26543 139.18.158.168 (8 Aug 2003 06:52:26 GMT)
X-Complaints-To: usenet@news.uni-leipzig.de
NNTP-Posting-Date: 8 Aug 2003 06:52:26 GMT
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.4) Gecko/20030624
X-Accept-Language: de, de-at, en, en-us
In-Reply-To: <3212284.1060257283@dbforums.com>
Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:82468

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