Abnormal behavior, please help [message #258500] |
Sun, 12 August 2007 16:41 |
gs77
Messages: 7 Registered: August 2006
|
Junior Member |
|
|
Hi,
I have two forms F1 and F2. I used CALL_FORM to call F2.
F1 has one control block and one database block. F2 has same.
Both the forms have KEY-COMMIT trigger and use COMMIT_FORM to
Commit (bypassing form's own commit mechanism). Both the forms
associated with database tables have database triggers just to
populate a few columns with sysdate and user only.
F1 does not have any issue at all.
There is no issue on navigating from F1 to F2. F2 does not have
any issue on Query, Insert, Update or Delete. Commit is also normal. Within no time Form acknowledges the changes. Upto this
point, I do not have any issue.
But when I hit F4 BUTTON to fire KEY-EXIT trigger it takes long time to close the form F2. The KEY-EXIT trigger does not have anything except EXIT_FORM.
If I do not Insert or Update in F2 then it does not take long time to close the form thru KEY-EXIT trigger.
I don't understand why F2 is behaving like that!! Any Clue?
Please help.
|
|
|
|
|
|
|
|
|
|
|
Re: Abnormal behavior, please help [message #259249 is a reply to message #259104] |
Tue, 14 August 2007 19:28 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Please post the code of your trigger.
Are you running the database on your PC? Are you getting the same timing issue if you run the forms on a different PC?
David
|
|
|