Home » Developer & Programmer » Forms » commiting changes in a block without a change
commiting changes in a block without a change [message #380639] Mon, 12 January 2009 15:57 Go to next message
sindikalac
Messages: 52
Registered: November 2008
Location: Europe
Member
Hi guys,

I don't understand this situation.

I got two data blocks, db1 and db2. I placed db1.item1 and two items from db2 on the same form (canvas). db1 and db2 are in master-detail relation via item1.

When I start a form, I got all values populated into items, but when I change item values in the second data block, and commit_form afterwords, then I get message that there were two transactions, which means both data blocks were updated, although I haven't changed a value in the first block (in item1), just in the second one. Why is this happening? I haven't changed a value in the first block and I got that message about updating both blocks, I need that item1 on the form, because those two blocks are connected via that item1.
Re: commiting changes in a block without a change [message #380678 is a reply to message #380639] Mon, 12 January 2009 23:58 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you using a standard master-detail form created by using the Forms Builer wizards or have you written your own code to populate the blocks?

David
Re: commiting changes in a block without a change [message #380722 is a reply to message #380678] Tue, 13 January 2009 02:26 Go to previous messageGo to next message
sindikalac
Messages: 52
Registered: November 2008
Location: Europe
Member
djmartin wrote on Mon, 12 January 2009 23:58
Are you using a standard master-detail form created by using the Forms Builer wizards or have you written your own code to populate the blocks?

David


I was using a wizard.
Re: commiting changes in a block without a change [message #380952 is a reply to message #380722] Wed, 14 January 2009 06:03 Go to previous messageGo to next message
h_jitendras
Messages: 36
Registered: October 2006
Member
Hi,
Is this solved?
can you post in detail the error message you are getting?

Thanks,
Re: commiting changes in a block without a change [message #381027 is a reply to message #380722] Wed, 14 January 2009 22:43 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You do not need to 'quote' the whole of the previous post, pressing 'reply' is good enough. Most of us are smart enough to read previous posts if the current post looks a bit cryptic.

Yes, please post the exact message that you are receiving.

Have you written any code yourself? If yes, do you get this behaviour if your code is 'commented out'?

David
Re: commiting changes in a block without a change [message #381419 is a reply to message #381027] Fri, 16 January 2009 18:00 Go to previous messageGo to next message
sindikalac
Messages: 52
Registered: November 2008
Location: Europe
Member
This is the exact message I got:
FRM-40400 Transaction complete: 2 records applied and saved.

(As I told you I made changes just in one record - item in the second data block.)

I don't get any error messages.
Re: commiting changes in a block without a change [message #381470 is a reply to message #381419] Sat, 17 January 2009 02:03 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Whats the relation u've got after using the wizard?
C:\Documents and Settings\javedk\Desktop\Snagit.bmp
Javed
Re: commiting changes in a block without a change [message #381475 is a reply to message #381470] Sat, 17 January 2009 02:20 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@sindikalac: I guess that *something* has changed in the first block's record as well. It might be, for example, a POST-QUERY trigger which populated certain items. In that case, you can "force" Forms to think that nothing has really happened by issuing
set_record_property(:system.trigger_record, 'first_block_name', status, query_status);


@Javed: it is useless posting an image which is stored on your disk. You have to upload it to the OraFAQ server because - we can't see it. Furthermore, don't post BMPs as they are far too large in size - post a PNG or a JPG instead.
Re: commiting changes in a block without a change [message #381479 is a reply to message #381475] Sat, 17 January 2009 02:27 Go to previous messageGo to next message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

My Opologies LF.
It wont happened again.
Javed

[Updated on: Sat, 17 January 2009 02:35]

Report message to a moderator

Re: commiting changes in a block without a change [message #381482 is a reply to message #381479] Sat, 17 January 2009 02:41 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Huh, I'm not complaining - I just wasn't able to see what you have attached (the "snaqit" image file). So, if you don't mind, do it once again.
Re: commiting changes in a block without a change [message #381483 is a reply to message #381482] Sat, 17 January 2009 02:47 Go to previous message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

Laughing
I was just asking our fellow about the kind of relation in both of the blocks (e.g. Master Detail, Cascade...) that Image was just to make him clear where to find the Relation but i think our freinds on orafaq are smarter enough to get the things without image to redirect. Now its a Habit developed itself to make everything documented with Images .. Cool (Bosses Order).

Javed
Previous Topic: submitting concurrent from PL/SQL problem
Next Topic: problem in save record
Goto Forum:
  


Current Time: Sun Dec 11 08:15:24 CST 2016

Total time taken to generate the page: 0.10907 seconds