OraFAQ Forum: Forms » Navigation problem between records in a multi block form

Home » Developer & Programmer » Forms » Navigation problem between records in a multi block form (Using Forms 10g & database 11g)

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

Navigation problem between records in a multi block form [message #639069]

Wed, 01 July 2015 00:27

mfarooq216
Messages: 9
Registered: May 2006
Location: Karachi (Pakistan)

Junior Member

Dear Experts,
Please guide me to resolve such problem as :
I have developed a form having 3 Database blocks, The actual problem is this that when I recorded some data in all three ( Master , detail & Subdetail ) blocks and retrived them. Now in detail block I am unable to move cursor from first recodr to next record.
Further for you clarification if I break the relation between detail & Subdetail block. Record navigation issue resolved and I can move or create record in detail block easily.

Please help me urgently as my project is stuck due to this problem.

Regards,

Muhammad Farooq

Report message to a moderator

Re: Navigation problem between records in a multi block form [message #639072 is a reply to message #639069]

Wed, 01 July 2015 01:01

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

Senior Member
Account Moderator

Quote:

I am unable to move cursor from first record to next record

How do you do that? With a mouse or using the keyboard?
Is there any trigger in detail block which might prevent navigation?
Did you try to run the form in debug mode and see what is going on when navigation should occur (but doesn't)?

Quote:

If I break the relation between detail & Subdetail block, Record navigation issue resolved

Did you create relationship between data blocks manually, or did you let the Data block Wizard to do that? Because, Wizard doesn't create *only* the relationship but also certain triggers and procedures. So, if you did that manually, maybe there's something missing which causes problems.

Report message to a moderator

Re: Navigation problem between records in a multi block form [message #639075 is a reply to message #639072]

Wed, 01 July 2015 04:17

mfarooq216
Messages: 9
Registered: May 2006
Location: Karachi (Pakistan)

Junior Member

Dear All,
I have solved the problem myself.
Duplicate name of relations found set them as unique and the problem resolved.

This post is to support all others who faced such kind of problem.

Regards,

Report message to a moderator

Re: Navigation problem between records in a multi block form [message #659514 is a reply to message #639075]

Thu, 19 January 2017 16:22

ghulam.butt
Messages: 1
Registered: January 2017

Junior Member

Hi Guys,

I had the same problem and resolved by doing the following:

When we create a relationship Oracle Forms automatically creates few triggers and procedures. Please check a procedure "CLEAR_ALL_MASTER_DETAILS" and go to the bottom and search for the code as below:

/*IF Get_Block_Property(curdtl, STATUS) <> 'NEW' THEN
Go_Block(curdtl);
Check_Package_Failure;
Clear_Block(NO_VALIDATE);
IF :System.Block_Status <> 'NEW' THEN
RAISE Form_Trigger_Failure;
END IF;
END IF;*/

Just comment this code and you are good to go.

Hope this helps

Ghulam

Report message to a moderator

Previous Topic:	Enabling all the chec kboxes when block is loaded in forms
Next Topic:	FRM-40735: ON-ERROR trigger raised unhandled exception ORA-06508

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 27 17:57:48 CST 2026