Home » Developer & Programmer » Forms » form changed (oracle forms builder 10g)
form changed [message #320416] Thu, 15 May 2008 01:45 Go to next message
vaibhavi
Messages: 21
Registered: April 2008
Junior Member
Hi,

I have one form that contains many text items.

When user exit the form then it should be checked whether user has made any change on the form. That means user has entered anything in any text item on the form.

I used System.Form_Status = 'CHANGED' but it checks only if the database record is there on the form.

Its urgent.
Please give me suggestions.

Thanks.
Re: form changed [message #320419 is a reply to message #320416] Thu, 15 May 2008 01:57 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
If you are using the default Forms behaviour, that is, you have NOT written your own 'insert', 'update', and 'delete' statements, and as long as you DON'T use either 'exit_form(no_commit)' or 'exit_form(no_validate)' then you will either be asked to save any changes or with 'exit-form(do_commit)', if the form believes you have changes to save, it will save them.

David

Upd: Typo

[Updated on: Thu, 15 May 2008 02:05]

Report message to a moderator

Re: form changed [message #320421 is a reply to message #320419] Thu, 15 May 2008 02:03 Go to previous messageGo to next message
vaibhavi
Messages: 21
Registered: April 2008
Junior Member
Hi,

Thanks for reply.

Means if I have any insert,update in my form through any trigger then exit_form(ask_commit) will ask to save changes for database record only?

And what if I have data block?

Thanks.
Re: form changed [message #320425 is a reply to message #320421] Thu, 15 May 2008 02:10 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
No. Oracle Forms does not SENSE manual 'insert', 'update', or 'delete' statements. You will have to either just 'save' using 'standard.commit' or set a control item or global when you DO do anything manually and then test to see if the item or global is set when you exit (usually in the 'key_exit' trigger).

David
Re: form changed [message #320435 is a reply to message #320425] Thu, 15 May 2008 02:25 Go to previous messageGo to next message
vaibhavi
Messages: 21
Registered: April 2008
Junior Member
Hello,

I have used exit_form(ask_commit) to check if form has changed or not.
I open one form, I select one value from LOV and then I get record of that value.
If I make change in that record and then tries to exit form it asks me to save the changes.

But if I am on another form that form does not fetch any value, it is for some other purpose.
When I write some word in one text item on that form and then tries to exit then it does not ask me to save or continue.

Thanks.
Re: form changed [message #320676 is a reply to message #320435] Thu, 15 May 2008 18:35 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Then we must assume that that item which you changed has been marked as a non-database item.

David
Re: form changed [message #320705 is a reply to message #320676] Fri, 16 May 2008 00:58 Go to previous messageGo to next message
vaibhavi
Messages: 21
Registered: April 2008
Junior Member
Hello,

Yes, if change in control item then I am not able to check form status as if data block item using form_status.

Thanks.
Re: form changed [message #321061 is a reply to message #320705] Sun, 18 May 2008 21:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I am gald that you agree with what I wrote. Does this mean that you have solved your problem or not?

David
Re: form changed [message #321124 is a reply to message #321061] Mon, 19 May 2008 03:13 Go to previous message
vaibhavi
Messages: 21
Registered: April 2008
Junior Member
Hi,

Yes. I am checking change with database item only.

Thank you for reply.
Previous Topic: How to use Varchar2 Varible with Cursor Parameter
Next Topic: radio button
Goto Forum:
  


Current Time: Mon Dec 05 05:07:55 CST 2016

Total time taken to generate the page: 0.07044 seconds