Forms 10g - commit all records or non - how to achieve?
Hello,
Let me start this discussion with the requirement.
1. I have a detail level block with some 10 fields and a status column.
2. Depending on logic validations in POST-QUERY, status will change to 'ERROR' or 'SUCESS'
3. I need to save updates to this data block ONLY IF all records show status of 'SUCCESS'. That means if there are 10 records in the block, and 9 show 'SUCCESS' but 1 shows 'ERROR' form MUST NOT commit changes to database.
How do I achieve this?
Thank you
Darsh