Home » Developer & Programmer » Forms » two blocks referring same table???
two blocks referring same table??? [message #83108] Thu, 07 August 2003 06:08 Go to next message
Victoria
Messages: 152
Registered: July 2002
Senior Member
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?

Thanx In Advance
~V~

Report message to a moderator

Re: two blocks referring same table??? [message #83123 is a reply to message #83108] Fri, 08 August 2003 11:37 Go to previous message
magnetic
Messages: 324
Registered: January 2003
Senior Member
items in both blocks are database items??
suppose you want to query when you run the form...
in the when-new-form instance:
go_block ('block1');
execute_query;
go_block ('block2');
execute_query;

Report message to a moderator

Previous Topic: update one form upon closing another
Next Topic: Screen
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 10:59:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.