Home » Developer & Programmer » Forms » reg:- when validate record
reg:- when validate record [message #192624] Wed, 13 September 2006 00:49 Go to next message
manyal
Messages: 84
Registered: March 2005
Member
Dear Friends,

I have applied when_validate_record trigger in detail block and raised form_trigger_failure within that if certain conditions arises, it works fine but it allows to go to any other record by mouse clicking even though the validation fails.

i want if when_validate_record trigger raises form_trigger_failure,cursor shud not be allowed to move to any other record.

thanx in advance....

Manyal

[Updated on: Wed, 13 September 2006 02:34] by Moderator

Report message to a moderator

Re: reg:- when validate record [message #192645 is a reply to message #192624] Wed, 13 September 2006 02:37 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please post the code that you have in your trigger.

David
Re: reg:- when validate record [message #192667 is a reply to message #192645] Wed, 13 September 2006 03:51 Go to previous messageGo to next message
manyal
Messages: 84
Registered: March 2005
Member
Dear David,
plez find the trigger as an attachment.
Manyal
  • Attachment: test.txt
    (Size: 1.75KB, Downloaded 1182 times)
Re: reg:- when validate record [message #192677 is a reply to message #192624] Wed, 13 September 2006 04:18 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

Set Validation Unit of Form To RECORD Level.

Hope It will work.

Sandy
Re: reg:- when validate record [message #192698 is a reply to message #192677] Wed, 13 September 2006 05:19 Go to previous messageGo to next message
manyal
Messages: 84
Registered: March 2005
Member
Dear Sandy,

I tried this but not working!!!!!!!
Re: reg:- when validate record [message #192897 is a reply to message #192698] Thu, 14 September 2006 02:57 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Does the message 'Some Remarks Must be Changed' ever get displayed? I assume from your other posts that when it is displayed the form still lets you move away from the record. Please confirm.

David
Re: reg:- when validate record [message #193184 is a reply to message #192897] Fri, 15 September 2006 03:19 Go to previous messageGo to next message
manyal
Messages: 84
Registered: March 2005
Member
dear david,

yeh it is diplayed at the bottom , i ran the form after removing message lines still i m able to move to other record.


Manyal
Re: reg:- when validate record [message #193537 is a reply to message #193184] Mon, 18 September 2006 02:49 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What is the current 'Validation Unit' in the Form?

Do you have any 'on-error' or 'on-message' triggers defined?

David
Re: reg:- when validate record [message #193551 is a reply to message #193537] Mon, 18 September 2006 03:55 Go to previous messageGo to next message
manyal
Messages: 84
Registered: March 2005
Member
no there is no such kind of triggers
icon14.gif  Re: reg:- when validate record [message #193680 is a reply to message #192624] Mon, 18 September 2006 23:56 Go to previous message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

HI
MANYAL

i hope you are fine.
you have set the message on null value.
dear friend too much messages confuse our application users.
to avoid that you should set the
Required Property = 'Yes' in the property palette of that field.
i will also keep your cursor on that field.

another solution is that you should use

raise form_trigger_failure;
after the message;
i hope this will work.

regard.

Muhammad Shahid Mughal
Faisalabad Pakistan

[Updated on: Tue, 19 September 2006 00:07]

Report message to a moderator

Previous Topic: giving names to excel field ...
Next Topic: Read BLOB Column in forms10g
Goto Forum:
  


Current Time: Fri Sep 20 11:34:13 CDT 2024