OraFAQ Forum: Forms » Detail Block is not clearing

Home » Developer & Programmer » Forms » Detail Block is not clearing (Forms 6i)

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

Detail Block is not clearing [message #616175]

Fri, 13 June 2014 00:36

chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India

Senior Member

Dear Friends,

I have a form with 3 database blocks and all are viewable in the same canvas. I have defined the relation between Block 1-2 and Block 2-3. Now i can enter and save data and when i navigate between records from the first block, then both the detail block fetches the correct data based on the relation successfully.

Now, the Problem is when i use F7 from first block, then block 1 and 2 only clears and block 3 is not clearing. Also when i try to create a new record using down arrow from the first block, then also block 3 is not clearing and holding the previous data.

How to solve this. There is no direct relation between Block 1-3. Is this the problem?

Properties of Relation is
1. Delete behaviour is Cascading
2. Prevent masterless operation is No
3. Deferred is No
4. Automatic Query is No

Thanks for your suggestion.

Report message to a moderator

Re: Detail Block is not clearing [message #616177 is a reply to message #616175]

Fri, 13 June 2014 01:03

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

Senior Member
Account Moderator

Open Forms Online Help, search for "About Complex Relations and Cascading Deletes", read it (especially "Detail with two masters") and see whether it helps.

Report message to a moderator

Re: Detail Block is not clearing [message #616181 is a reply to message #616177]

Fri, 13 June 2014 01:51

chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India

Senior Member

Thankyou.

Currently my scenario is not like a detail with 2 master blocks. It is like A-B and B-C are related. A is mater of B and B is master of C. All data entry and refreshing of data goes well. Only when F7 and creating new record is creating issue. Actually this should work fine, but i guess missing some extra code or property.

Report message to a moderator

Re: Detail Block is not clearing [message #616182 is a reply to message #616181]

Fri, 13 June 2014 01:57

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

Senior Member
Account Moderator

If it is about properties, I wouldn't know which ones.

If it is about additional coding, well, that shouldn't be a problem. F7 is "enter query", I suppose. That would be the KEY-ENTQRY trigger on the block A:

go_block('C'); 
clear_block;
go_block('A');
enter_query;

The same would be used in KEY-CREREC trigger (you'd substitute ENTER_QUERY with CREATE_RECORD).

Report message to a moderator

Re: Detail Block is not clearing [message #616183 is a reply to message #616182]

Fri, 13 June 2014 02:05

chat2raj.s
Messages: 163
Registered: October 2010
Location: Chennai, India

Senior Member

Thankyou. Problem is solved now with this code during Querying. But i cant use the same Go_block during when create record as it is a restricted built in.

Report message to a moderator