Home » Developer & Programmer » Forms » Validation in Multirecord Block
Validation in Multirecord Block [message #388327] Tue, 24 February 2009 06:07 Go to next message
drajeshonline
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.

thanks

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
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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'.

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


Current Time: Fri Dec 09 02:20:58 CST 2016

Total time taken to generate the page: 0.11721 seconds