How to commit ONE block only...
Hi Guys,
I have 2 database blocks in my form. In one block user can select and enter fields from a LOV. And in other record he can enter new records and save. This is the most common senerio of my form.
But in some case he can enter new record in the first block and can enter new records in the second block.
The problem i am facing is that if user select an existing record from a LOV and then on the basis of these values he enter an other record in the second block.. COMMIT_FORM also tries to save the record in the first block and as the record already exists it gives error "unbale to insert record" i want to commit only the second block but in some cases i have to commit both blocks.
Kindly suggest me what to do please.
Imran Baig