|
|
|
|
| Re: How to use post procedure in forms 6i [message #383757 is a reply to message #383756] |
Fri, 30 January 2009 00:25   |
 |
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
POST writes data in the form (that includes inserts, updates and deletes) to the database, but does not commit. You can later commit changes by explicitly COMMITing or rollback by using the CLEAR_FORM built-in.
It is used by calling it as any other procedure, no difference. Just be careful as it is a restricted procedure (so you can't call it from any trigger you'd like it to).
For more information, open Forms Online Help System and read about POST built-in and use of restricted procedures.
As of urgency implied by your second message: note that you are visiting a forum. Nobody here waits for anyone's message in order to "respond quickly". You may get the answer sooner, later or never (though, on Forms forum, you'll eventually get the reply). If your problem really is urgent (which, in my opinion, use of the POST built-in is not), hire a consultant or contact Oracle Support Service. Here, on the forum, all you can do is to be patient.
|
|
|
|
| Re: How to use post procedure in forms 6i [message #383948 is a reply to message #383753] |
Sat, 31 January 2009 23:58 |
snsiddiqui
Messages: 172
Registered: December 2008
|
Senior Member |
|
|
Dear
Thanks for the reply.
I am using POST to remove any item from LOV which user have already selected or want to stop if he insert again manually therefore I check if all necessary fields are filled then I use POST in my trigger.
But the problem is users are complaining that the form goes to hang when they insert any item.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
