Oracle Forms (MOSC)

MOSC Banner

Forms 10g - commit all records or non - how to achieve?

edited Jun 3, 2017 5:00AM in Oracle Forms (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center