Home » Developer & Programmer » Forms » :System.Mode
:System.Mode [message #268345] Tue, 18 September 2007 04:50 Go to next message
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
Re: :System.Mode [message #268349 is a reply to message #268345] Tue, 18 September 2007 05:14 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Sinida,
Try to set the ITEM_IS_VALID property to TRUE in post_query after the assignment.

By
Vamsi
Re: :System.Mode [message #268381 is a reply to message #268349] Tue, 18 September 2007 06:38 Go to previous messageGo to next message
sinida1984
Messages: 83
Registered: September 2007
Location: India
Member
Hi Vamsi,

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

Regards,
Sinida
Re: :System.Mode [message #268503 is a reply to message #268345] Tue, 18 September 2007 23:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: :System.Mode [message #268514 is a reply to message #268503] Tue, 18 September 2007 23:56 Go to previous message
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
Previous Topic: Called Form Debugging
Next Topic: Screen Resolution
Goto Forum:
  


Current Time: Fri Dec 09 15:46:27 CST 2016

Total time taken to generate the page: 0.40094 seconds