Home » Developer & Programmer » Forms » validate from list (10g , dev 6i, xp)
validate from list [message #393928] Wed, 25 March 2009 00:19 Go to next message
rzkhan
Messages: 345
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 #394986 is a reply to message #393928] Mon, 30 March 2009 23:46 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have a 'When-Validate-Item' trigger on this non-dtabase field? Does the LOV populate any other items? Do you have 'Auto Confirm' turned on for this LOV?

David
Re: validate from list [message #395136 is a reply to message #393928] Tue, 31 March 2009 08:00 Go to previous messageGo to next message
rzkhan
Messages: 345
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 #395146 is a reply to message #393928] Tue, 31 March 2009 08:26 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is one of those other items a database item?
Re: validate from list [message #395257 is a reply to message #393928] Tue, 31 March 2009 23:16 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
Yes.

There are two return items.

Item1 is a Non-Database 
and 
Item2 is a Database item

[Updated on: Tue, 31 March 2009 23:17]

Report message to a moderator

Re: validate from list [message #395346 is a reply to message #393928] Wed, 01 April 2009 03:31 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Are you changing the value of the non-database item at any point?
Re: validate from list [message #395421 is a reply to message #393928] Wed, 01 April 2009 07:08 Go to previous messageGo to next message
rzkhan
Messages: 345
Registered: March 2005
Senior Member
No


Quote:

closing the form without inserting, updating, deleting any record , a message is displayed "do you want to save the changes?".


Re: validate from list [message #395478 is a reply to message #393928] Wed, 01 April 2009 10:33 Go to previous messageGo to next message
cookiemonster
Messages: 12422
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 messageGo to next message
cookiemonster
Messages: 12422
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 messageGo to next message
rzkhan
Messages: 345
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 messageGo to next message
cookiemonster
Messages: 12422
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 #395893 is a reply to message #395702] Fri, 03 April 2009 00:21 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is this field item defined as being a copy of another item or is it being copied by another item?

David
Re: validate from list [message #509511 is a reply to message #393928] Sun, 29 May 2011 01:05 Go to previous messageGo to next message
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!
Re: validate from list [message #509516 is a reply to message #509511] Sun, 29 May 2011 02:09 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't ask your question in multiple places. We can see the thread you created.
Previous Topic: Error in oracle forms 10g (merged 3)
Next Topic: Default values in Oralce Forms
Goto Forum:
  


Current Time: Thu Dec 08 19:53:44 CST 2016

Total time taken to generate the page: 0.08205 seconds