Hi all,
I am having a strange scenario in one of my applications. I have a form with header and detail part. Sometimes, When a user saves a record (pressing F10) the detail part gets appended to the previous record and header part is not at all saving.
ie, consider a record with bill no :22944 which has one header record & one detail record. The next bill no should be 22945. Upon saving second record with one header & one detail, the header part is not saving anywhere and the detail part is saving with header code as the previous record (header code of bill no.24944). Now bill no.24944 has 2 detail record and one bill(24945) is missing.
This is not happening for each record, but rarely this pops up.
on key-commit I have a commit_form statement and a procedure to save ledger details. I tried using pre-update, post-update,on-update triggers to null for both header & detail. But not working
my form version is :Oracle Forms 10g
Database version : Oracle 11g
Can anyone please help me in finding what the actual cause may be.
Thanks&Regards
JaKes