Home » Developer & Programmer » Forms » show message reshow window after update
show message reshow window after update [message #634933] Wed, 18 March 2015 03:09 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
hi all,
i have a window(include a canvas and a block database)for show information of a person.
this window shown by another window.
user can update information in this window.
i used a procedure in database for update and used finally in procedute this code:
/*codes for update ....*/
  commit;

this procedure called by button(in when-button-press).
update performed but when i close and reshow window,first show message(in attachment.)
why?
  • Attachment: 2.JPG
    (Size: 10.50KB, Downloaded 199 times)

[Updated on: Wed, 18 March 2015 03:10]

Report message to a moderator

Re: show message reshow window after update [message #634934 is a reply to message #634933] Wed, 18 March 2015 03:18 Go to previous messageGo to next message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you update values in a database block (whose items are based on table columns), why do you use a stored procedure to do that job? You are doing it twice and encounter a message you attached. Why? Because Forms knows that you modified items and asks you whether you'd want to save those changes or not.

So: omit procedure call, do everything you want to do in a form.
Re: show message reshow window after update [message #634936 is a reply to message #634934] Wed, 18 March 2015 03:36 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
i love that user used button for Insert,update,delete operation.
buttons that in bottom in windows....
Re: show message reshow window after update [message #634937 is a reply to message #634936] Wed, 18 March 2015 03:48 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
for example i update a value of field and click on button Save but show message :
frm-40509 oracle error:unable to update record.
Re: show message reshow window after update [message #634945 is a reply to message #634937] Wed, 18 March 2015 05:00 Go to previous messageGo to next message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Then, instead of letting users modify values in a database block, let them do that in a control block (i.e. cut it off of the database).
Re: show message reshow window after update [message #634957 is a reply to message #634933] Wed, 18 March 2015 06:38 Go to previous messageGo to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
i usually used a block for all operations(show,insert,delete,update data).
if i use a control block then i need use of code for all operation!!namely post one in above Smile
Re: show message reshow window after update [message #634965 is a reply to message #634957] Wed, 18 March 2015 07:52 Go to previous message
Littlefoot
Messages: 21578
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
hahaie

message #634936: i love that user used button for Insert,update,delete operation.

message #634957: i usually used a block for all operations(show,insert,delete,update data)


So, which one of these is true? The first one suggest that you write your own code for these operations. The second one is just the opposite.
Previous Topic: DEBUG.SUSPEND
Next Topic: RAISE FORM_TRIGGER_FAILURE NOT WORKING
Goto Forum:
  


Current Time: Mon Aug 03 15:31:45 CDT 2020