OraFAQ Forum: Forms » show message reshow window after update

Home » Developer & Programmer » Forms » show message reshow window after update

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

show message reshow window after update [message #634933]

Wed, 18 March 2015 03:09

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 795 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

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: show message reshow window after update [message #634936 is a reply to message #634934]

Wed, 18 March 2015 03:36

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....

Report message to a moderator

Re: show message reshow window after update [message #634937 is a reply to message #634936]

Wed, 18 March 2015 03:48

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.

Report message to a moderator

Re: show message reshow window after update [message #634945 is a reply to message #634937]

Wed, 18 March 2015 05:00

Littlefoot
Messages: 21807
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).

Report message to a moderator

Re: show message reshow window after update [message #634957 is a reply to message #634933]

Wed, 18 March 2015 06:38

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

Report message to a moderator

Re: show message reshow window after update [message #634965 is a reply to message #634957]

Wed, 18 March 2015 07:52

Littlefoot
Messages: 21807
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.

Report message to a moderator

Previous Topic:	DEBUG.SUSPEND
Next Topic:	RAISE FORM_TRIGGER_FAILURE NOT WORKING

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 19:58:13 CDT 2024