| Three blocks form execution problem [message #398828] |
Sat, 18 April 2009 00:13  |
snsiddiqui
Messages: 172
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 #399604 is a reply to message #399600] |
Thu, 23 April 2009 02:28  |
snsiddiqui
Messages: 172
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 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
