Home » Developer & Programmer » Forms » Forms multi-row validation
Forms multi-row validation [message #431508] Tue, 17 November 2009 17:06 Go to next message
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
Messages: 17
Registered: July 2009
Location: Austin, TX, USA
Junior Member

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
Messages: 12
Registered: June 2009
Junior Member
As suggested by Balaji

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

Re: Forms multi-row validation [message #433371 is a reply to message #431508] Wed, 02 December 2009 00:06 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS 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.

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

Current Time: Sat Jul 22 14:20:43 CDT 2017

Total time taken to generate the page: 0.09710 seconds