?
Solved

try to commit in WHEN-VALIDATE-ITEM

Posted on 2003-03-13
7
Medium Priority
?
1,214 Views
Last Modified: 2009-03-24
i want to issue a commit command in the when-validate-item on an item placed in the control block. But COMMIT is not allowed in WHEN-VALIDATE_ITEM. any help as to how this can be achieved. I dont want to use the block level trigger WHEN-NEW-ITEM-INSTANCE.
0
Comment
Question by:vikramrathour
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 15

Expert Comment

by:andrewst
ID: 8126979
One way to get around this is to use a TIMER.
1) In the WHEN-VALIDATE-ITEM trigger, create a TIMER that expires immediately.
2) In the WHEN-TIMER-EXPIRED trigger do the COMMIT.
0
 

Author Comment

by:vikramrathour
ID: 8127108
Thanx andrew
But the problem is i am deploying my forms on 9iAS and TIMER is not a feasible option across the internet...
0
 
LVL 15

Expert Comment

by:andrewst
ID: 8127192
In that case, you may need to change your design to match the capabilitities of Forms.  For example, add a button to do the COMMIT.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:vikramrathour
ID: 8127224
ok...
What i have done is i have written the commit in when-new-item-instance at block level..this solves my problem...can you just tell me whether what i did is a better option or i can use timer..?
0
 
LVL 15

Expert Comment

by:andrewst
ID: 8127347
I think you can use a timer for this purpose - the timer will only run once per validation, so it will not create any network issues.  What is unacceptable is having a REPEATING timer that repeats rapidly and therefore creates a lot of network traffic.
0
 
LVL 13

Expert Comment

by:anand_2000v
ID: 10094038
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

PAQ with points refunded

Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

anand_2000v
EE Cleanup Volunteer
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10148234
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question