Home » Developer & Programmer » Forms » Detail Block is not updating & showing data
Detail Block is not updating & showing data [message #684126] Thu, 08 April 2021 07:15 Go to next message
Messages: 1
Registered: April 2021
Junior Member
Dear sir,

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

Now, the Problem is when i use F7 from first block & change its date (date cloumn is relation both block)& save it then in block 2 dose not change it. and now in child block data does not show when i run F7 query but in sql data shows .
but the date relation which i created both block does not match.
How to solve this problam if i change data in master block specially in relation cloumn the chiled block also update itself ?

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

Thanks for your suggestion.
Re: Detail Block is not updating & showing data [message #684142 is a reply to message #684126] Thu, 08 April 2021 14:43 Go to previous message
Messages: 21811
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Detail block contains a date item. Navigate to its "Data properties" and investigate what
- copy value from item
- synchronize with item
properties do. See if setting them to master block's data item helps in your case.
Previous Topic: LOV position
Next Topic: import excel by column mapping using oracle 6i form
Goto Forum:

Current Time: Fri May 24 20:44:07 CDT 2024