| PLZ HELP ME ! URGENT ! [message #86174] |
Mon, 06 September 2004 21:35  |
domingo
Messages: 54
Registered: June 2004
|
Member |
|
|
Hi
In my form i have two screens , i need to page down to second screen when there is corresponding data available in screen 2 its working fine but when no data is available corresponding to first screen , i get error message on paging down to second screen and it keeps on coming and i cannot get out of it . I have to then end the program by pressing ctrl+alt+del
Can anybody help me ?
Its urgent plz let me know if u hav any questions.
Thanks
DOMINGO
|
|
|
|
| Re: PLZ HELP ME ! URGENT ! [message #86187 is a reply to message #86174] |
Tue, 07 September 2004 23:20  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Waht do you mean by 2 screens?
Are these 2 separate Fprms or there are 2 separate blocks in the Form?
If they are separate forms then add following code in On-message trigger:
If Message_code = 40350 Then
Message('I: No record exists for the query criterion entered.',NO_ACKNOWLEDGE);
Else
If Message_Code <> 0 Then
Message('I: ' || To_Char(Message_Code) || ' ' || Message_Text,NO_ACKNOWLEDGE) ;
Raise Form_Trigger_Failure;
End If ;
End If;
Also check if you have appropriate error handling exceptions written in your When-new-form-instance(I beleive you are executing the query from this trigger only) , and also expetion handling should be done in key-execqry trigger.
I hope that you are using call_form built-in to call the 2nd form.I have tested this with call form trigger and it works fine.
HTH
Regards
Himanshu
|
|
|
|
|
|
|
|
| Re: PLZ HELP ME ! URGENT ! [message #86196 is a reply to message #86193] |
Wed, 08 September 2004 01:23 |
domingo
Messages: 54
Registered: June 2004
|
Member |
|
|
himanshu
i tried putting a on eror trigger but now u know what's happenning ..?
Its always showing working and i cannot come out of the form
can u tell me the problem ?
regds
Domingo
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
