Home » Developer & Programmer » Forms » Oracle forms (oracle forms6i)
Oracle forms [message #510140] Thu, 02 June 2011 10:42 Go to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

Hi,

can we create two datablocks(header&line) based on one table in oracle forms.any way to create?i don't go for master-detail.always facing this issue.

regards,
rajendar
Re: Oracle forms [message #510142 is a reply to message #510140] Thu, 02 June 2011 10:46 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
Probably. You'd have to explain the data structure before we can tell you how.
Re: Oracle forms [message #510160 is a reply to message #510142] Thu, 02 June 2011 11:50 Go to previous messageGo to next message
Littlefoot
Messages: 18826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Rajendar
Always facing this issue

What issue?
Re: Oracle forms [message #510208 is a reply to message #510160] Thu, 02 June 2011 22:43 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

can we create two datablocks(header&line) based on one table.
Re: Oracle forms [message #510223 is a reply to message #510208] Fri, 03 June 2011 00:11 Go to previous messageGo to next message
Littlefoot
Messages: 18826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Yes.

[EDIT] However, I prefer to call them "master" and "detail" instead of "header" and "line" (never even heard of such a terminology within Oracle Forms).

[Updated on: Fri, 03 June 2011 00:12]

Report message to a moderator

Re: Oracle forms [message #510224 is a reply to message #510223] Fri, 03 June 2011 00:22 Go to previous messageGo to next message
rajendaroracle
Messages: 80
Registered: May 2011
Location: India
Member

I know master-detail but according to my requirement i have only one custom table so based on that i need to create.you said it is possible how? If i have multiple rows then in line level?

[Updated on: Fri, 03 June 2011 00:25]

Report message to a moderator

Re: Oracle forms [message #510232 is a reply to message #510224] Fri, 03 June 2011 01:32 Go to previous messageGo to next message
Littlefoot
Messages: 18826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Example based on Scott's EMP table:

  • using Data Block Wizard, create a master block. Its base table is EMP, the only column you'll choose is DEPTNO
  • create its layout - form style (which means that you'll see only one item on a canvas)
  • create another block (using Data Block Wizard again). It will be a detail block.
  • Its base table is EMP again. This time select ALL items.
  • Create master-detail relationship (manually, within the Wizard) by joining DEPTNO items from both blocks
  • layout should be "tabular"; display as many records as you wish (10, for example)
  • run the form. While in master block, perform query. It (master block) will contain 14 records (if the EMP table is the "original" one), and you'll scroll through 14 DEPTNO values (some of them will be duplicate, of course). Detail records will automatically change, as you scroll through master records

That should be all, I suppose.
Re: Oracle forms [message #593077 is a reply to message #510232] Tue, 13 August 2013 20:45 Go to previous message
sumanthllr
Messages: 15
Registered: April 2013
Junior Member
In this case can we organize in Oracle Applications Form as
Deptno   20
Sal      3000

Empno   Ename    
7369    SMITH 
7566    JONES   
7788    SCOTT


The above all are text items the master block has Deptno and Sal.
The detail block has Empno, Ename, Deptno, Sal.
The detail block should display multiple records.
The relation is the Deptno
Based on the Deptno,Sal the details should be queried as well as when key in the new data it stores multiple records like..

Empno   Ename   Sal   Deptno
null    null    3000  20
7369    SMITH   null  20
7566    JONES   null  20
7788    SCOTT   null  20


How to get rid of multiple records?
Previous Topic: Cusrsor Control in FIND box when LOV invoked
Next Topic: Master Detail form storing multiple records
Goto Forum:
  


Current Time: Fri Apr 18 20:49:17 CDT 2014

Total time taken to generate the page: 0.09091 seconds