OraFAQ Forum: Forms » New Visual in Oracle Forms (Master / Detail)

Home » Developer & Programmer » Forms » New Visual in Oracle Forms (Master / Detail) (Form 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

New Visual in Oracle Forms (Master / Detail) [message #541586]

Wed, 01 February 2012 04:48

usmanelahi
Messages: 54
Registered: July 2007
Location: Karachi

Member

Hello Engineers,

Hope you all are fine and doing very well, I have created a simple master/detail form which is in easy navigation for user

The form have master/detail block with tabular style showing 5 records, When user click on master record the detail will show the opposite as master record point

See attached file hope will give me better solution.

/forum/fa/9785/0/

Attachment: master_detail_visual2.JPG
(Size: 130.62KB, Downloaded 1680 times)

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541588 is a reply to message #541586]

Wed, 01 February 2012 04:53

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

So what is the problem?

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541589 is a reply to message #541586]

Wed, 01 February 2012 04:55

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

tabular style showing 5 records

I see much more than 5 records, but OK, never mind that.

Quote:

When user click on master record the detail will show the opposite as master record point (...) hope will give me better solution

What's wrong with this solution? What would you want to improve?

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541591 is a reply to message #541589]

Wed, 01 February 2012 05:00

usmanelahi
Messages: 54
Registered: July 2007
Location: Karachi

Member

how to do with code i adjust manually in form to show you as attachment

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541593 is a reply to message #541591]

Wed, 01 February 2012 05:03

usmanelahi
Messages: 54
Registered: July 2007
Location: Karachi

Member

hope you will give me better solution

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541596 is a reply to message #541593]

Wed, 01 February 2012 05:06

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

You don't need any code. As long as a relationship is defined between the two blocks forms will sort it all out for you.

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541597 is a reply to message #541596]

Wed, 01 February 2012 05:08

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

If it is just about form "beauty", perhaps you could shorten a master block (to 5 records, as you said) and put a detail block below it.

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541605 is a reply to message #541586]

Wed, 01 February 2012 05:25

usmanelahi
Messages: 54
Registered: July 2007
Location: Karachi

Member

I think you don't understand Please see attached file again and tell me how can i do that

when navigate to any record from master the block detail block should automatically move i adjust manually to show you as attached

Attachment: master detail new visual.pdf
(Size: 329.97KB, Downloaded 1332 times)

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541608 is a reply to message #541605]

Wed, 01 February 2012 05:27

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Ah, I see! Put a detail block to a stacked canvas and move it around.

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541609 is a reply to message #541605]

Wed, 01 February 2012 05:32

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

Well you didn't explain it very clearly.
Put the detail block in a stacked canvas.
Add a when-new-record-instance trigger to the master block that uses set_view_property to change the stacked canvases VIEWPORT_Y_POS property as appropriate.

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541611 is a reply to message #541609]

Wed, 01 February 2012 05:38

usmanelahi
Messages: 54
Registered: July 2007
Location: Karachi

Member

yes thanks a lot but how to get viewport_y_pos property size or get cursor position i am new in oracle

Report message to a moderator

Re: New Visual in Oracle Forms (Master / Detail) [message #541613 is a reply to message #541611]

Wed, 01 February 2012 05:43

cookiemonster
Messages: 13937
Registered: September 2008
Location: Rainy Manchester

Senior Member

you know the y position of the top of the master block. You can work out the distance between the top of one record and the next.
Those numbers, along with the current row number are what you need. Just experiment with it.

Report message to a moderator

Previous Topic:	how to stop going to next record if it is the last record?
Next Topic:	how to hide a stacked canvas?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Aug 23 16:46:51 CDT 2024