| problem in working with on_error trigger [message #331183] |
Wed, 02 July 2008 08:46  |
vamsikgummadi
Messages: 62
Registered: April 2006
Location: United States, MI
|
Member |
|
|
Hi Friends,
I have developed an application in which I have used the on_error trigger to capture the error . I have used this trigger so that no duplicate values can be inserted. When running the form it works fine. Now suppose I am inserting a duplicate record it is alreting that I cannot insert a duplicate value in the field.
Once this message is displayed I am making the entries made into that particular fields ( that particular entire record empty).
So the user needs to enter a new record. Suppose the user does not wish to enter a new reord at this point and wishes only to move across the various records being displayed then he should be able to do that.
But in my form I am unable to do that and the error I am getting is
ELSE:FRM-40202:Field must be entered
This might be due to the else part I have used in on_error trigger.
| Quote: | Is there any way such that a user can use clear_record in on_error trigger so that the user can go to previous and next records once he gets the error message when he tries to insert the duplicate record.
|
It would also be helpful if you can provide me the code snippets if possible. Please let me know if you have any other questions in order to help me in working out this problem.
Thanks and regards,
Vamsi K Gummadi
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
