Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1280
  • Last Modified:

try to commit in WHEN-VALIDATE-ITEM

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
vikramrathour
Asked:
vikramrathour
1 Solution
 
andrewstCommented:
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
 
vikramrathourAuthor Commented:
Thanx andrew
But the problem is i am deploying my forms on 9iAS and TIMER is not a feasible option across the internet...
0
 
andrewstCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
vikramrathourAuthor Commented:
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
 
andrewstCommented:
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
 
anand_2000vCommented:
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
 
Computer101Commented:
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now