Home » Developer & Programmer » Forms » Abnormal behavior, please help
Abnormal behavior, please help [message #258500] Sun, 12 August 2007 16:41 Go to next message
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 #258513 is a reply to message #258500] Sun, 12 August 2007 20:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What version of Forms and database are you using?

David
Re: Abnormal behavior, please help [message #258721 is a reply to message #258513] Mon, 13 August 2007 08:14 Go to previous messageGo to next message
gs77
Messages: 7
Registered: August 2006
Junior Member
It is version 6i.

Thanks.
Re: Abnormal behavior, please help [message #258947 is a reply to message #258721] Mon, 13 August 2007 19:19 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have any triggers on the database table referred to in F2?

David
Re: Abnormal behavior, please help [message #258950 is a reply to message #258500] Mon, 13 August 2007 19:30 Go to previous messageGo to next message
gs77
Messages: 7
Registered: August 2006
Junior Member
Yes. But it just populates two columns with sysdate and user
on Insert or Update.

Thanks
Re: Abnormal behavior, please help [message #258953 is a reply to message #258950] Mon, 13 August 2007 19:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Disable the trigger and see if you get any performance change.

David
Re: Abnormal behavior, please help [message #258954 is a reply to message #258953] Mon, 13 August 2007 20:11 Go to previous messageGo to next message
gs77
Messages: 7
Registered: August 2006
Junior Member
Thanks for reply. I do not have any issue till Commit.
Commit is very fast and the form also acknowledges the
changes applied to database and saved.
Re: Abnormal behavior, please help [message #258955 is a reply to message #258954] Mon, 13 August 2007 20:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Does this mean that your problem is solved?

David
Re: Abnormal behavior, please help [message #259104 is a reply to message #258955] Tue, 14 August 2007 07:20 Go to previous messageGo to next message
gs77
Messages: 7
Registered: August 2006
Junior Member
No. After successful commit, if I want to close the
form it takes long time. I have KEY-EXIT trigger and
it has EXIT_FORM only.
Re: Abnormal behavior, please help [message #259249 is a reply to message #259104] Tue, 14 August 2007 19:28 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: FRM-92101 error
Next Topic: how to disable system alerts?
Goto Forum:
  


Current Time: Sat Dec 10 10:59:12 CST 2016

Total time taken to generate the page: 0.04812 seconds