Home » Developer & Programmer » Forms » detail block not displaying values when master block is executed (forms 10g)
detail block not displaying values when master block is executed [message #394151] Wed, 25 March 2009 18:54 Go to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
hi,

i have 3 blocks. block A,B and C.

A is master block to B (B is detail block to A)

B is master block to C.(C is detail block to B)

when i query the form, blocks A and B displays the values.

but C doesnt display.

block C displays values only when i click in block C.

what is the reason for this?? how to solve this problem??


thanks
jillu
Re: detail block not displaying values when master block is executed [message #394165 is a reply to message #394151] Wed, 25 March 2009 22:23 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Please check coordination property in B block Relation.

Deferred property and automatic query may be "Yes" and change to NO.

kanish

[Updated on: Wed, 25 March 2009 22:26]

Report message to a moderator

Re: detail block not displaying values when master block is executed [message #394350 is a reply to message #394165] Thu, 26 March 2009 09:46 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
i changed it as you said. still its not working.

deferred was 'yes' and automatic query was 'No' before. i made both as 'No'.

coordination property for relation in block A is deferred='yes', automatic query='No'. but block B is displaying values when block A is executed. then why is block C not displaying values until i click on that block??

jillu
Re: detail block not displaying values when master block is executed [message #394361 is a reply to message #394350] Thu, 26 March 2009 11:19 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
i solved the issue.

i deleted on-populate-details trigger and on-clear-details trigger which i had written on block B. this solves my problem.

but iam not sure why this works when i delete them.
Re: detail block not displaying values when master block is executed [message #394392 is a reply to message #394361] Thu, 26 March 2009 14:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Probably because you should pay more attention to triggers created by wizard. Basically, Forms do that job very efficiently and there's no need to write your triggers which would emulate Forms' ones.
Re: detail block not displaying values when master block is executed [message #394401 is a reply to message #394392] Thu, 26 March 2009 16:12 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
but now there is no on-populate-details or on-clear-details trigger present in block B.

is this correct. i read that when we are creating relation, then these 2 triggers should be present even if they have NULL in them.

is there any workaround for this, like coding in other triggers such that these 2 triggers are not necessary. ?

thanks
jillu
Re: detail block not displaying values when master block is executed [message #394460 is a reply to message #394151] Fri, 27 March 2009 04:32 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
As far as I'm aware those triggers are very necessary.

Try deleting the relationships and recreating them via the datablock wizard.
Re: detail block not displaying values when master block is executed [message #394527 is a reply to message #394460] Fri, 27 March 2009 12:10 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
there are on-populate-details trigger and on-clear details trigger in form level. might be that is taking care.

i have got other issue in other form.

let me explain you.

i have 3 blocks. suppose 'A', 'B','C'.

A is master block to B (B is detail block to A)

B is master block to C.(C is detail block to B)

now we want to get rid of block 'A'.so that block B is the first block in the form and C is the next block (below block B).

now i deleted the relation in block A and made all the items in block A as invisible. and i positioned the block B as first block after ctrl block in object navigator. and i made required property of items in block A as 'No'.
and also in when-new-form-inst trigger iam writing
go_block('B') i tried go_item('B.name') also.

now when i compile the form and open the application iam getting below error:

frm-40106:no navigable items found in destination block.

i know that go_block is refering block A ,thats why iam getting error.

but block A is no more master block as i deleted the relation it had and is also not the first block in the object navigator.

even though iam getting same error. what is the root cause for it??

can i delete block A from object navigator?? does this solve my problem?
but its not right to delete the block as we may need it in future.

thanks
jillu

Re: detail block not displaying values when master block is executed [message #394557 is a reply to message #394527] Fri, 27 March 2009 15:04 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
i solved the issue,

solution is:
open property pallette of the module (right click on module name-> open property).

i gave the first navigation block as B.

now its working fine, it opens form and have cursor on B block. but iam getting other issue here.

when the form is opened and iam getting the same error at the bottom of the form. error is below:

frm-40106:no navigable items found in destination block.

why am i getting this error again??

other issue iam getting is, when i query for some record and click on the detail blocks its fine. but when i click on the B block from detail blocks , B blcok is getting executed and its showing the values which were displayed at the form opening.

how to solve this?
Re: detail block not displaying values when master block is executed [message #394570 is a reply to message #394557] Fri, 27 March 2009 16:51 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
i found out that block A is still acting as master block. hence iam getting that error.

in when-new-block-instance trigger at form level, i wrote few messages and i could find out that block A is still acting as master block.thats why ism getting this error.

can you tell me how to solve this issue?

Re: detail block not displaying values when master block is executed [message #394574 is a reply to message #394570] Fri, 27 March 2009 18:37 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
there is a cursor in a function in a PLL which returns A as the master block.
i cant change PLL as its restricted.

is there any harm if i hide the error frm-40106 ??

and i tried using :system.message_level='20' and '0' both in on-error trigger of block B.
even though its showing the error message.

what should i do??
Re: detail block not displaying values when master block is executed [message #394625 is a reply to message #394574] Sat, 28 March 2009 16:00 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you are navigating to a block, make sure it contains at least one enterable item. Once you do that, error will disappear (so you won't have to think about hiding it).
Re: detail block not displaying values when master block is executed [message #394692 is a reply to message #394625] Sun, 29 March 2009 18:12 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
but i dont want to show block A in the form, then where is the point of navigation??

i want to show block B as first block and block A as second block.
i want to get rid of block A. i dont want block A.

and block B has enterable fields.

as i told about a query in cursor. its fetching min(seq) from ao_mods table. and min(seq) is block A. so obviousle block A is assigned for master_block.


Re: detail block not displaying values when master block is executed [message #394753 is a reply to message #394151] Mon, 30 March 2009 03:04 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you don't want block A just delete it.
Oracle forms does a lot of stuff for you so getting it to ignore a data block is quite difficult.
Also even if you sort it out, having an unused block is just going to confuse anyone who works on the form after you.

EDIT:typo

[Updated on: Mon, 30 March 2009 03:05]

Report message to a moderator

Re: detail block not displaying values when master block is executed [message #394910 is a reply to message #394753] Mon, 30 March 2009 17:13 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
but i dont want to delete block A. we may use it in future.


Re: detail block not displaying values when master block is executed [message #394911 is a reply to message #394151] Mon, 30 March 2009 17:24 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
That's one of the reasons why source control was invented.

Keeping obsolete code in forms (or anything else for that matter)
is good for two things
1) confusing other developers.
2) causing bugs.

just delete it.
Re: detail block not displaying values when master block is executed [message #394981 is a reply to message #394911] Mon, 30 March 2009 23:32 Go to previous messageGo to next message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
as block A is a value in a tabele called ao_blks, the cursor is getting that value.

i have to delete that value from that table so that it fetchs block B.

but its not coorect to delete value A from the table.

is there no other solution??
Re: detail block not displaying values when master block is executed [message #395124 is a reply to message #394151] Tue, 31 March 2009 07:08 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Now I'm really confused.

Who said anything about deleting data from a table?
I certainly didn't - I suggested you delete the datablock from the form (in form builder).

What is this cursor?

Is there a relationship between block A and block B?
You said a while back that you got rid of the relationship but your lastest post seems to imply a relationship still exists.
Re: detail block not displaying values when master block is executed [message #395245 is a reply to message #395124] Tue, 31 March 2009 21:12 Go to previous message
nastyjillu
Messages: 211
Registered: February 2009
Senior Member
we have all the block names in a table called ao_block.
we have module names in a table called ao_modules.
same with fields.

so there is a cursor in a PLL which gets value of l_master_block parameter as block A.
that is why A acts as master block.
even though i delete datablock A, it doesnt make difference.

so i have to make changes in table.

my leader is working on it. we have to do something about data.

thanks for help.

will let u know what we did to solve
Previous Topic: Problem in Showing Alert
Next Topic: problem while saving
Goto Forum:
  


Current Time: Fri Dec 09 19:16:17 CST 2016

Total time taken to generate the page: 0.06779 seconds