Home » Developer & Programmer » Forms » Forms Personalization Validating a Multi-Record Block (2 Merged) (Oracle 10G)
Forms Personalization Validating a Multi-Record Block (2 Merged) [message #565656] Wed, 05 September 2012 21:02 Go to next message
Messages: 1
Registered: September 2012
Location: Philippines
Junior Member
Hi ,

I have a problem validating a multi-record block. I need to put the validation after the user clicks save. The custom validation should run through all the records in the multi-record block. But instead of validating all records, it will only validate the record where the cursor is located before the user hits save.

Any idea? Appreciate your feedback.
Re: Forms Personalization Validating a Multi-Record Block (2 Merged) [message #565661 is a reply to message #565656] Thu, 06 September 2012 00:45 Go to previous message
Messages: 18820
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This sounds like an Oracle Apps. question (and I know nothing about it) so - sorry if the following means nothing in that context.

Anyway: why wouldn't you validate every record in a trigger Oracle designed for that purpose: WHEN-VALIDATE-RECORD? For example: you enter values into the first record. Then, you navigate to the second record. WHEN-VALIDATE-RECORD fires and does its job. If it fails, you need to fix it. The process repeats for every record you enter. Finally, SAVE only saves changes you've made as all records are already validated.
Previous Topic: Forms 6i Key-help not fired under application
Next Topic: problem in retrieving record
Goto Forum:

Current Time: Wed Apr 16 03:08:17 CDT 2014

Total time taken to generate the page: 0.09368 seconds