Home » Developer & Programmer » Forms » Detail Block is not clearing (Forms 6i)
Detail Block is not clearing [message #616175] Fri, 13 June 2014 00:36 Go to next message
chat2raj.s
Messages: 161
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.
Re: Detail Block is not clearing [message #616177 is a reply to message #616175] Fri, 13 June 2014 01:03 Go to previous messageGo to next message
Littlefoot
Messages: 21805
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.
Re: Detail Block is not clearing [message #616181 is a reply to message #616177] Fri, 13 June 2014 01:51 Go to previous messageGo to next message
chat2raj.s
Messages: 161
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.
Re: Detail Block is not clearing [message #616182 is a reply to message #616181] Fri, 13 June 2014 01:57 Go to previous messageGo to next message
Littlefoot
Messages: 21805
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).
Re: Detail Block is not clearing [message #616183 is a reply to message #616182] Fri, 13 June 2014 02:05 Go to previous messageGo to next message
chat2raj.s
Messages: 161
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.
Re: Detail Block is not clearing [message #616184 is a reply to message #616183] Fri, 13 June 2014 02:11 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I didn't say WHEN-CREATE-RECORD but KEY-CREREC.
Re: Detail Block is not clearing [message #616186 is a reply to message #616184] Fri, 13 June 2014 02:49 Go to previous message
chat2raj.s
Messages: 161
Registered: October 2010
Location: Chennai, India
Senior Member
Thankyou. Issue is solved based on your suggestions.
Previous Topic: help help gobat60.exe has stopped working windows 8
Next Topic: insert image into database filed by Scaner/camera in form 6i
Goto Forum:
  


Current Time: Tue Mar 19 06:44:01 CDT 2024