OraFAQ Forum: Forms » detail block not displaying values when master block is executed

Home » Developer & Programmer » Forms » detail block not displaying values when master block is executed (forms 10g)

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

detail block not displaying values when master block is executed [message #394151]

Wed, 25 March 2009 18:54

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

Report message to a moderator

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

mm_kanish05
Messages: 493
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

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

Report message to a moderator

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

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.

Report message to a moderator

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

Littlefoot
Messages: 21823
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.

Report message to a moderator

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

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

Report message to a moderator

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

cookiemonster
Messages: 13963
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.

Report message to a moderator

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

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

Report message to a moderator

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

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?

Report message to a moderator

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

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?

Report message to a moderator

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

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??

Report message to a moderator

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

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

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.

Report message to a moderator

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

cookiemonster
Messages: 13963
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

nastyjillu
Messages: 211
Registered: February 2009

Senior Member

but i dont want to delete block A. we may use it in future.

Report message to a moderator

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

cookiemonster
Messages: 13963
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.

Report message to a moderator

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

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??

Report message to a moderator

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

cookiemonster
Messages: 13963
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.

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	Problem in Showing Alert
Next Topic:	problem while saving

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 20:52:19 CST 2025