OraFAQ Forum: Forms » :System.Mode

Home » Developer & Programmer » Forms » :System.Mode

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

:System.Mode [message #268345]

Tue, 18 September 2007 04:50

sinida1984
Messages: 83
Registered: September 2007
Location: India

Member

Hi all,
I am facing with a problem in Forms that some validations of 'When-validate-item' trigger is executing when i query a record. In post-query i have assigned a value to a non database item.That non database item has a when validate item trigger in which there is some codes to come data into a database field. Is there any provision 'if it is queried one,this when-validate-item's code should not execute. I tried both :System.mode and :System.record_status...and checked if it is 'QUERY' not to execute. But still some message is coming from that When-validte-item. Can anyone help me in finding this

Regards
Sinida

Report message to a moderator

Re: :System.Mode [message #268349 is a reply to message #268345]

Tue, 18 September 2007 05:14

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Sinida,
Try to set the ITEM_IS_VALID property to TRUE in post_query after the assignment.

By
Vamsi

Report message to a moderator

Re: :System.Mode [message #268381 is a reply to message #268349]

Tue, 18 September 2007 06:38

sinida1984
Messages: 83
Registered: September 2007
Location: India

Member

Hi Vamsi,

The problem got rectified as you said. Thank you so much............

Regards,
Sinida

Report message to a moderator

Re: :System.Mode [message #268503 is a reply to message #268345]

Tue, 18 September 2007 23:37

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

When you have any doubts about the value of something like ':system.mode' or ':system.record_status', use a 'message/pause' pair to display its value so that you can test for it in the next interation of your code.

David

Report message to a moderator

Re: :System.Mode [message #268514 is a reply to message #268503]

Tue, 18 September 2007 23:56

sinida1984
Messages: 83
Registered: September 2007
Location: India

Member

Hi david,
I checked the values of the system variables. But it was coming as 'QUERY' only. Thnk u...

Bye
Sinida

Report message to a moderator

Previous Topic:	Called Form Debugging
Next Topic:	Screen Resolution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 13:32:33 CDT 2025