form changed [message #320416] |
Thu, 15 May 2008 01:45 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](/forum/images/custom_avatars/67467.jpg) |
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS 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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #320435 is a reply to message #320425] |
Thu, 15 May 2008 02:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #320705 is a reply to message #320676] |
Fri, 16 May 2008 00:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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.
|
|
|
|
|