OraFAQ Forum: Forms » Oracle forms

Home » Developer & Programmer » Forms » Oracle forms

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

Oracle forms [message #552823]

Sun, 29 April 2012 01:30

siva123
Messages: 6
Registered: July 2007
Location: chennai

Junior Member

my form have two block one is master..another one is details ...
in details have 10 field...one field in date field .. suppose each record entering date field last record date fiels value is show on master block one field...

Report message to a moderator

Re: Oracle forms [message #552825 is a reply to message #552823]

Sun, 29 April 2012 01:39

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Quote:

one field in date field .. suppose each record entering date field last record date fiels value is show on master block one field...

Question not clear.need more detail.

Regards,
Irfan

Report message to a moderator

Re: Oracle forms [message #552827 is a reply to message #552825]

Sun, 29 April 2012 01:49

siva123
Messages: 6
Registered: July 2007
Location: chennai

Junior Member

Refer the attachments

Attachment: reference.txt
(Size: 0.46KB, Downloaded 1060 times)

Report message to a moderator

Re: Oracle forms [message #552828 is a reply to message #552827]

Sun, 29 April 2012 01:56

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Describe your table structure & Master-Detail Relationship.?

Report message to a moderator

Re: Oracle forms [message #552829 is a reply to message #552828]

Sun, 29 April 2012 01:57

siva123
Messages: 6
Registered: July 2007
Location: chennai

Junior Member

Both field are date column

Report message to a moderator

Re: Oracle forms [message #552830 is a reply to message #552829]

Sun, 29 April 2012 02:04

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Describe your master-detail tables relationship not field data type.

Report message to a moderator

Re: Oracle forms [message #552831 is a reply to message #552830]

Sun, 29 April 2012 02:15

siva123
Messages: 6
Registered: July 2007
Location: chennai

Junior Member

Thank u for your efforts

Report message to a moderator

Re: Oracle forms [message #552836 is a reply to message #552831]

Sun, 29 April 2012 05:52

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

Senior Member
Account Moderator

I don't have Forms here to test it myself, but you might try the following: in POST-RECORD detail block level trigger (or WHEN-VALIDATE-ITEM on detail block's date item trigger) do something like

:master_block.date_item := :detail_block.date_item;

Report message to a moderator

Re: Oracle forms [message #552838 is a reply to message #552836]

Sun, 29 April 2012 06:05

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Mr.Littlefoot Mr.siva123 wants this.

Quote:

Master form

field 1

field 2 --- Here i need update the date column based on details block field value

details block

field1 field2 field 3

Note :

Record1 10 10 10-jan-2010

record2 20 15 15-jan-2011

record3 30 20 20-apr-2012

First record entering stage 10-jan-2010 show to master field2
second record entering stage 15-jan-2011 show to master field
.
.
.
.
etc

In this scenario did he have right logic.?

Regards,
Irfan

Report message to a moderator

Previous Topic:	invalid cursor using SYS_REFCURSOR
Next Topic:	Execute query by pressing a button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 21:42:22 CDT 2024