validate from list [message #393928] |
Wed, 25 March 2009 00:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
Hi
I have a non-database text item (name: profession_temp) on a block and it is a also return item for an lov.
When I change the property "validate from list" of the item(name: profession_temp), to YES, and closing the form without inserting, updating, deleting any record , a message is displayed "do you want to save the changes?".
When I change the above property back to "No", the message is not displayed in this case. I wonder why this message appears while there is no change occurred in the underlying records?
please guide me...
Thanks
RzKhan
[Updated on: Wed, 25 March 2009 23:34] Report message to a moderator
|
|
|
|
Re: validate from list [message #395136 is a reply to message #393928] |
Tue, 31 March 2009 08:00 ![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) |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
Quote: | Do you have a 'When-Validate-Item' trigger on this non-dtabase field?
| NO
Quote: | Does the LOV populate any other items?
| YES
Quote: | Do you have 'Auto Confirm' turned on for this LOV?
| NO
|
|
|
|
|
|
|
Re: validate from list [message #395478 is a reply to message #393928] |
Wed, 01 April 2009 10:33 ![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) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Presumably at some point the non-database item is being validated. This is in turn modifying the database item which is changing the record status, which in turn is causing the form to ask if you want to save changes.
I don't know why the validation is firing on the non-database item but I can only assume there is some code somewhere in your form that is the cause.
I can only suggest you put message calls in various triggers to show you the item_is_valid property of the non-database item. At some point in your form it's going to change. If we can work out which trigger it's happening in and which line of code we can resolve this.
|
|
|
Re: validate from list [message #395479 is a reply to message #393928] |
Wed, 01 April 2009 10:38 ![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) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
One other question:
Are you querying data when this happens?
And if so are you setting the value of the non-database item in a post-query trigger?
(ok two questions)
|
|
|
Re: validate from list [message #395699 is a reply to message #393928] |
Thu, 02 April 2009 05:19 ![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) |
rzkhan
Messages: 370 Registered: March 2005
|
Senior Member |
|
|
Quote: |
there is some code somewhere in your form that is the cause
|
I am sure there is no such code which modify any item value.
Quote: |
Are you querying data when this happens?
|
Answer: NO
|
|
|
Re: validate from list [message #395702 is a reply to message #393928] |
Thu, 02 April 2009 05:37 ![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) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Then I don't know what to suggest.
maybe someone else can think of something.
But I've never seen an oracle form decide a record is changed just because validate_from_list is set to Yes.
|
|
|
|
Re: validate from list [message #509511 is a reply to message #393928] |
Sun, 29 May 2011 01:05 ![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) |
moe_k
Messages: 18 Registered: November 2009 Location: Lebanon
|
Junior Member |
|
|
hello .. im having the exact same problem.
however im filling the non database item in the post query..
can anyone please help!
|
|
|
|