Home » Developer & Programmer » Forms » Three blocks form execution problem (Oracle10g, Forms6i)
Three blocks form execution problem [message #398828] Sat, 18 April 2009 00:13 Go to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
Dear gurus,

I developed a form which contains three different database blocks (master + detail + sub detail) where user inserts date and other details in master block, detail block contains items which user wants to produce and sub-detail block contains items which will be consume by the production of above item.

After the item code insertion in detail block I am fetching consumption items their percentages in sub-detail block then user move to production qty field to insert qty at that time I am calculating quantities, rates and amount in sub-detail block then user moves to next record in detail block so I am using POST in my detail block to avoid "DO YOU WANT TO SAVE THE CHANGES" message. I have pre-insert trigger in all blocks.

Master block pre-insert trigger performing addition in id and document code.
Detail block pre-insert trigger performing addition in id, updating stock (addition), calculating their rates and inserting values in item ledger table.
Sub-detail block pre-insert trigger updating of stock (subtraction) and inserting values in item ledger table.

Problem is values are saving permanently in tables when post is fired.

Please give me your good suggestions to resolve this issue or if you have any other idea by the development of this form then I will appreciate.


Thanks in advance.

[Updated on: Sat, 18 April 2009 03:58]

Report message to a moderator

Re: Three blocks form execution problem [message #399418 is a reply to message #398828] Wed, 22 April 2009 02:48 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I would suggest inserting entries into 'item ledger' table in the POST-Insert trigger.

Do you have any 'forms_ddl' statements in your form?

David
Re: Three blocks form execution problem [message #399586 is a reply to message #399418] Thu, 23 April 2009 01:48 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
No, I am not using forms_ddl.
Re: Three blocks form execution problem [message #399593 is a reply to message #399586] Thu, 23 April 2009 02:03 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have any 'interesting' code in your form?

David
Re: Three blocks form execution problem [message #399596 is a reply to message #398828] Thu, 23 April 2009 02:08 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
you mean if I add forms_ddl in my coding then my form will become an interesting one.

what type of interest you required?
Re: Three blocks form execution problem [message #399600 is a reply to message #399596] Thu, 23 April 2009 02:14 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have any data structure changing code? Do you call any database base functions or procedures?

I assume that you do NOT have a 'commit' or 'form_commit' statements in any of your code. Is this correct?

David
Re: Three blocks form execution problem [message #399604 is a reply to message #399600] Thu, 23 April 2009 02:28 Go to previous messageGo to next message
snsiddiqui
Messages: 168
Registered: December 2008
Senior Member
No, there isn't any data structure chainging in my coding, I am not using any function/procedure/package in my coding and also I am not using commit/form_commit in my coding.

I am just using POST in my coding because I don't want to save data until and unless user press SAVE button otherwise it should not record/impact any change.
Re: Three blocks form execution problem [message #399607 is a reply to message #399604] Thu, 23 April 2009 02:37 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I believe that with a bit of playing around you should be able to get everything to work without the POST commands as well.

I would suggest trying again with a new form which you populat eusign the block and relations wizards and placing the 'item ledger' table statements in the POST-Insert trigger at the block level.

David
Previous Topic: Getting ORA-01775: looping chain of synonyms error
Next Topic: Disable Button
Goto Forum:
  


Current Time: Sat Dec 03 22:39:41 CST 2016

Total time taken to generate the page: 0.10964 seconds