Home » Developer & Programmer » Forms » Forms 6i updation problem
Forms 6i updation problem [message #151506] Thu, 15 December 2005 03:47 Go to next message
rajilkulkarni2002
Messages: 2
Registered: December 2005
Junior Member
I am using forms 6i in my application. I have made a form using
two tables for making delivery order. in this i am fetching
sales order information from two more table and reverse updating
the dispatched quantity. Now while making delivery order , if
inbetween i click on cancel button (code contains only
clear_block(no_commit) ) and then if i press exit button (code
contains only exit_form(no_commit) ), it updates the records of
sales order table. I've not used post any where in my form. I've
tried to roll back the things forcefully still it is updating
the records.What shoule i do. Pl help.


tks.

Raj
Re: Forms 6i updation problem [message #151614 is a reply to message #151506] Thu, 15 December 2005 20:21 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
How many 'commit' and 'commit_form' commands do you have in your form and 'commit' commands in your database code?

One of them is causing the problem.

David

AND STOP PRESSING CR-LF AT THE END OF EACH LINE!!!!!!

[Updated on: Thu, 15 December 2005 20:22]

Report message to a moderator

Re: Forms 6i updation problem [message #151632 is a reply to message #151614] Thu, 15 December 2005 23:14 Go to previous messageGo to next message
rajilkulkarni2002
Messages: 2
Registered: December 2005
Junior Member
Only one commit_form statement that too on save button. I checked once again and found one key-exit trigger on form level in which only clear_block(no_commit) was written. Now i've changed it to clear_form(no_commit,no_validate),still it is not working. One thing I would like to tell you that I've called this form using call_form() option.

tks.

Raj
Re: Forms 6i updation problem [message #151746 is a reply to message #151632] Sun, 18 December 2005 23:24 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry ... I have no idea.

I assume that you do NOT have any logic in your database concerning these two or four tables.

I can only suggest that you start a new version of this form and build and test it bit by bit.

David
Re: Forms 6i updation problem [message #152120 is a reply to message #151506] Wed, 21 December 2005 04:34 Go to previous message
Oracle_learn
Messages: 1
Registered: December 2005
Location: Pakistan
Junior Member
Dear use CLEAR_FORM(NO_VALIDATE) in your cancel button code instead of yours clear_block call
Previous Topic: Trigger Help
Next Topic: FRM-41810 when adding ON-LOGON trigger
Goto Forum:
  


Current Time: Fri Sep 20 07:49:00 CDT 2024