Oracle Forms

Hi,

I have requirement to check duplicate values on a multi data-block form before committing the changes.

I have created a table in database level which will save records for the validation.

INSERT INTO check_duplicate (exception_id,

                            EFFECTIVE\_START\_DATE,

                            EFFECTIVE\_END\_DATE,

                            CONTRACT\_NUMBER,

                            VALID\_FROM,

                            VALID\_TO)

    VALUES (:XXCSS\_MCCR\_AD\_CON\_EXCEP\_HDR.exception\_id,

          :XXCSS\_MCCR\_AD\_CON\_EXCEP\_HDR.EFFECTIVE\_START\_DATE,

            :XXCSS\_MCCR\_AD\_CON\_EXCEP\_HDR.EFFECTIVE\_END\_DATE,

            :XXCSS\_MCCR\_AD\_CON\_EXCEP\_DTL.CONTRACT\_NUMBER,

            :XXCSS\_MCCR\_AD\_CON\_EXCEP\_DTL.VALID\_FROM,

            :XXCSS\_MCCR\_AD\_CON\_EXCEP\_DTL.VALID\_TO );

i am not clear about one thing is if i use FORMS_DDL('COMMIT'); will it save the records in those tables also on which the master and detail blocks are created.because i dont want to save those records until they are not perfect.

Pleae find the design of my form

Now i have to check that for one contract number there should be only on record.

valid from date and vatlid date should not overlap each other or should not be equal

so i am planning to insert any new record into database and check for duplicates.

Please help me clearing this confusion.

Message was edited by: piyush9010