Home » Developer & Programmer » Forms » validation of item by comparing with another item of previous record in a multirecord block (FORMS 6i)
validation of item by comparing with another item of previous record in a multirecord block [message #336584] Mon, 28 July 2008 05:16 Go to next message
venkatadeekshi
Messages: 17
Registered: October 2007
Junior Member
Hi all,

I developed a form in which some of the blocks are multirecord blocks.One of the multirecord block have 3 items in it.

The user may enter data like this

FROM TO RATE
0 1000 10.0
1000 2000 9.0
2000 3000 8.5

My requirement is the FROM field value of the 2nd record should not be less than the TO field value of 1st record. The FROM field value of the 3rd record should not be less than TO field value of the 2nd record and so on...

i.e the form should not allow the user to enter data like this

FROM TO RATE
0 1000 10.0
900 2000 9.0
800 3000 8.5


Can anyone suggest me how to do this?

Thanks & Regards
Re: validation of item by comparing with another item of previous record in a multirecord block [message #336624 is a reply to message #336584] Mon, 28 July 2008 07:35 Go to previous message
dillango
Messages: 145
Registered: January 2008
Senior Member
Before moving to the next record, assign the "TO" value into a global variable. Now you can compare the "from" value of current record with the global variable.

Previous Topic: Setting Visual attribute differrent for diffrrent record in tabular block
Next Topic: Current_Row_White_On_Black
Goto Forum:
  


Current Time: Fri Dec 09 06:17:30 CST 2016

Total time taken to generate the page: 0.12475 seconds