Home » Developer & Programmer » Forms » Forms multi-row validation
Forms multi-row validation [message #431508] Tue, 17 November 2009 17:06 Go to next message
vamsij
Messages: 1
Registered: November 2009
Junior Member
Forms Multi-row validation

I have a requirement to show a validation error 'At least one reviewer should have more than zero amount limit'.
So we need identify highest amount limit entered in multiple rows, that highest amount limit should be >=1 if not show an error.

Level Reviewer Amt limit
1 ABC 0
2 MNP 0
3 XYZ 0

In the above case I need show an error msg. I tried pre-insert. It didn't work because built-in not supports pre-inserts.

Pls advice the best methodology to has shown error in this kind of scenario.



Re: Forms Multi-row validation [message #431534 is a reply to message #431508] Tue, 17 November 2009 23:53 Go to previous messageGo to next message
calluru
Messages: 17
Registered: July 2009
Location: Austin, TX, USA
Junior Member
Hi,

Have you tried the when-validate-record trigger in the block level?

-- Balaji
Re: Forms multi-row validation [message #432466 is a reply to message #431508] Tue, 24 November 2009 06:12 Go to previous messageGo to next message
coolbunny111
Messages: 12
Registered: June 2009
Junior Member
As suggested by Balaji

When validate record is the best suitable trigger to resolve your problem.

>>Coolbunny<<
Re: Forms multi-row validation [message #433371 is a reply to message #431508] Wed, 02 December 2009 00:06 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Create a new item, make its 'Calculation mode' 'Summary', make its 'Summary Function' 'Max', and then test that it is greater than zero.

David
Previous Topic: Logon to another database
Next Topic: Developer 6i Installation Problem
Goto Forum:
  


Current Time: Sat Dec 03 14:10:30 CST 2016

Total time taken to generate the page: 0.09447 seconds