OraFAQ Forum: Forms » FRM-40106 No navigable items IN DESTINATION block

Home » Developer & Programmer » Forms » FRM-40106 No navigable items IN DESTINATION block

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

FRM-40106 No navigable items IN DESTINATION block [message #628562]

Wed, 26 November 2014 05:28

tara_260985
Messages: 46
Registered: November 2014

Member

when I click on my add button in the form, it gives me this error FRM-40106 No navigable items IN DESTINATION block.
I have attached the screenshot of my form.
Kindly advise

Attachment: error.png
(Size: 69.55KB, Downloaded 1109 times)

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628568 is a reply to message #628562]

Wed, 26 November 2014 05:39

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

Senior Member
Account Moderator

As it says, there's no item in current block you can put cursor into. Which block does the ADD button belong to? Maybe you should first GO_BLOCK, and then do whatever you do in the WHEN-BUTTON-PRESSED trigger.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628571 is a reply to message #628568]

Wed, 26 November 2014 05:43

tara_260985
Messages: 46
Registered: November 2014

Member

ADD Button belongs to itemxref number block.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628573 is a reply to message #628571]

Wed, 26 November 2014 05:44

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

Senior Member
Account Moderator

So, is there any item in ITEMXREF block which has the "Input" property enabled?

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628574 is a reply to message #628571]

Wed, 26 November 2014 05:45

tara_260985
Messages: 46
Registered: November 2014

Member

my add button calls below procedure which has Go_block

PROCEDURE P_ADD IS
BEGIN
Go_Block('B_AAP_ITEM_XREF');
if :B_ITEMATTR.ITEM is NOT NULL then
Last_Record;
Next_Record;
end if;
Execute_Trigger('WHEN-NEW-RECORD-INSTANCE');
Go_Block('B_apply');
---
EXCEPTION
when FORM_TRIGGER_FAILURE then
raise;
when OTHERS then
emessage (SQLERRM);
raise FORM_TRIGGER_FAILURE;
END;

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628576 is a reply to message #628574]

Wed, 26 November 2014 05:49

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

Senior Member
Account Moderator

Which one of GO_BLOCK raises the error? If you aren't sure, put MESSAGE calls into the trigger and you'll know. Maybe it is not B_APP_ITEM_XREF but B_APPLY.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628588 is a reply to message #628576]

Wed, 26 November 2014 06:25

tara_260985
Messages: 46
Registered: November 2014

Member

@ Littlefoot;yes it has few items which has insert/update property to "YES" but has set its visible property to Hide in the canvas

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628590 is a reply to message #628588]

Wed, 26 November 2014 06:31

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

Senior Member

Hiden items aren't navigable by definition. You need a non-hidden item.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628597 is a reply to message #628590]

Wed, 26 November 2014 06:49

tara_260985
Messages: 46
Registered: November 2014

Member

there are 6 items in B_APP_ITEM_XREF block, where 3 are visible in table format (item_xref_num,company_id,supplier) as shown in the image sent to u.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628598 is a reply to message #628597]

Wed, 26 November 2014 06:53

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

Senior Member
Account Moderator

But, are they enterable?

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628603 is a reply to message #628598]

Wed, 26 November 2014 06:59

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

Senior Member

All three items appear to be display items, if so, they're not navigable.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628604 is a reply to message #628603]

Wed, 26 November 2014 07:05

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

Senior Member

If you want to have a block the user can't enter into then you need to add a navigable item the users can't see - make an item navigable and set it's height and width to 0.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628605 is a reply to message #628604]

Wed, 26 November 2014 07:18

tara_260985
Messages: 46
Registered: November 2014

Member

the text field down the table is used to enter data on the click of add button.
but the table is not used to enter data..it is in protected mode.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628606 is a reply to message #628605]

Wed, 26 November 2014 07:24

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

Senior Member
Account Moderator

If that's the case, why do you need the ADD button? Users should simply click into the first (white colored) item and enter value into it, then navigate to the second and the third item.

You are making things more complex than they should be. How do you plan to DELETE records?

If there was a simple (wizard-created) data block, that form would work normally ages ago.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628609 is a reply to message #628606]

Wed, 26 November 2014 07:39

tara_260985
Messages: 46
Registered: November 2014

Member

the add button will on show the records what user is adding but wont do commit unless user presses the OK button.
User requirement was to be designed in dat way

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628610 is a reply to message #628609]

Wed, 26 November 2014 07:39

tara_260985
Messages: 46
Registered: November 2014

Member

but now how will I resolve the issue of FRM-40106 No navigable items IN DESTINATION block.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628611 is a reply to message #628610]

Wed, 26 November 2014 07:43

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

Senior Member
Account Moderator

As you were told, by setting at least one item in that block navigable.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628675 is a reply to message #628611]

Wed, 26 November 2014 23:51

tara_260985
Messages: 46
Registered: November 2014

Member

I tried creating an item which is navigable but not visible to user...but still same error message pops up:-(

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628676 is a reply to message #628675]

Thu, 27 November 2014 00:14

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

Senior Member
Account Moderator

Well, either Oracle is not telling the truth, or you are not telling the truth. There's no 3rd option.

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628677 is a reply to message #628676]

Thu, 27 November 2014 00:19

tara_260985
Messages: 46
Registered: November 2014

Member

Reqest you to kindly check the attachment of my form hw it looks like back end.

Attachment: ERROR1.png
(Size: 93.71KB, Downloaded 1061 times)

Report message to a moderator

Re: FRM-40106 No navigable items IN DESTINATION block [message #628690 is a reply to message #628677]

Thu, 27 November 2014 01:33

tara_260985
Messages: 46
Registered: November 2014

Member

I created a new item again and I am not getting that error message...
Thanks @Littlefoot

Report message to a moderator

Previous Topic:	Login window Error
Next Topic:	increase table value

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 20:15:05 CDT 2024