Home » Developer & Programmer » Forms » Validation in Multirecord Block
Validation in Multirecord Block [message #388327] Tue, 24 February 2009 06:07 Go to next message
Messages: 11
Registered: February 2009
Junior Member
Hi all
please help me I got stuck to solve this problem ..problem is like ..I ma having a multi record block which is used to calculate the Interest Rate for a given period.So I need to validate the Interest period whether it is being used earlier.in case if it is used user is not allowed to choose that start period. so to achieve this I need to check the previos record start date also since in when-validate-item we can not navigate i m using key-next-item.it s woeking fine ..So can anybody tell me same validation I canacheive by using When-validate-item.


Rajesh Lionel
Re: Validation in Multirecord Block [message #388707 is a reply to message #388327] Thu, 26 February 2009 00:00 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I suggest doing a 'commit' each time you go to the next record, that way any used 'period' will exist in the database.

Then in the 'When-Validate-Item' trigger you do a search of the database and if the 'period' has been 'used' just do a 'raise form_trigger_failure'.

Previous Topic: TREE MENU
Next Topic: Error frm-92101
Goto Forum:

Current Time: Thu Aug 17 21:55:14 CDT 2017

Total time taken to generate the page: 0.13369 seconds