| Data Committing problem (No Changes to Save) [message #153226] |
Fri, 30 December 2005 02:46  |
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
|
Member |
|
|
HI
I am using Oracle Form 6i.
In one form I have 3 blocks:
1. HEADER - Database Block
2. Control Block.
3. DETAILS - Database BLock
Now fields:
1. Bank Code : Part Of COntrol BLock on Canvas
2. Branch : Part of Control BLock on Canvas
During run-time User Inputs Values in above 2 fields
which I pass to my DETAILS - Database Block while committing data.
IN Post Query Value I fetch values
for Bank Code and Branch and Display at Runtime in my
COntrol BLock.
No when I wish to change these values,
While Updating there is no chnage in database Values.
The reason for this is, none of the Database BLock Status
have changed. So data is not committed.
What is the Best way so that my HEADER and DETAILS both
get Updated even though no changes directly on any fields
belonging to those Blocks.
In short what code should I write to Change the Status.
This shall help me in updating my Audit Trail Fields and
Summarised totals also in header BLock.
Thks
Atul P
[Updated on: Fri, 30 December 2005 02:50] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Data Committing problem (No Changes to Save) [message #153471 is a reply to message #153390] |
Mon, 02 January 2006 13:24  |
RJ.Zijlstra
Messages: 104
Registered: December 2005
Location: Netherlands - IJmuiden
|
Senior Member |
|
|
Almost there....
Put in your POST-BLOCK trigger the following code:
Set_Record_Property( 1, 'YOUR_BLOCK_NAME', STATUS, CHANGED_STATUS);
(for both blocks -HEADER and DETAILS- and ONLY in this trigger)
It will force an update everytime.
HTH,
Regards
R Zijlstra
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
