Home » Developer & Programmer » Forms » How should I know if a block is related to another block (Oracle forms 6i)
How should I know if a block is related to another block [message #338737] Tue, 05 August 2008 20:02 Go to next message
anna marie
Messages: 26
Registered: June 2006
Location: Philippines
Junior Member
I have to check if a block is related to another block. If I have block_A and I create relation there to relate block_A and block_B. Now, I'm in Block_B, let's say I want to check if block_B is related to any other block, what is the quikiest way for me to know that it isa related to block_A?
Re: How should I know if a block is related to another block [message #338801 is a reply to message #338737] Tue, 05 August 2008 23:52 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
Get_Block_property('Block_B' , First_detail_relation)


if Block_B is related to any other master Block , Return Relation name else return null.
Re: How should I know if a block is related to another block [message #341670 is a reply to message #338801] Tue, 19 August 2008 21:49 Go to previous messageGo to next message
anna marie
Messages: 26
Registered: June 2006
Location: Philippines
Junior Member
Thanks for your reply.
Is there other way for this? I want to see relationship at design mode, not at run time. There's lot of problem so that I need to determine relationships, so that I can fix some errors and run this form.
Re: How should I know if a block is related to another block [message #341676 is a reply to message #341670] Tue, 19 August 2008 23:06 Go to previous messageGo to next message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
You Can determine by using the Detail Data Block property of Relations object .Which is created Under master block.
Re: How should I know if a block is related to another block [message #341951 is a reply to message #341676] Wed, 20 August 2008 19:51 Go to previous messageGo to next message
anna marie
Messages: 26
Registered: June 2006
Location: Philippines
Junior Member
So there is no way to find the master block if i'm in detail block? The only way is to open all data blocks' Relations Object and check if a particular (detail) block exist there?
Oh my, I have to check hundred of blocks in every form. thanks anyway. Razz
Re: How should I know if a block is related to another block [message #342009 is a reply to message #341951] Thu, 21 August 2008 01:13 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
How many blocks do you have in your forms?

David
Re: How should I know if a block is related to another block [message #342046 is a reply to message #342009] Thu, 21 August 2008 02:58 Go to previous message
anna marie
Messages: 26
Registered: June 2006
Location: Philippines
Junior Member
Hi David,

It's just typical form with around 50 blocks. But if i'm going to check 20 forms, this will take time. Anyway, it's not that big deal, I just thought there is an easy way. Razz
Previous Topic: memory usage ???
Next Topic: Encapsulating Oracle Forms Runtime exes and registry
Goto Forum:
  


Current Time: Sun Dec 11 04:03:57 CST 2016

Total time taken to generate the page: 0.10175 seconds