Oracle Forms

Hi guys!!! Here again!.

Ok, here are my two questions.

Both are different questions related to the same Error message.

*1.* I have a form with a DB Block which it is allow to insert, update and delete. When deleting using the built-in Delete_Record, the register of the DB deletes, but when I make a Commit, the error ORA-01400 comes up: "You cannot make an Null insert". I don't get it because what I make was a DELETE_RECORD and after that, to Commit.

What's going on?

I've tried to set the block insert property to false, but then a pop-up comes out saying ''It haven't make an insert'' which shouldn't come out.

Of course, the Form isn't as easy as Delete_Record + Commit, but since the Delete_Record makes it right, I don't understand why the ORA-01400 comes out exactly when Commit.

*2.* And, in another form I have something which is strange. I have a master-detail DB Blocks. When running the application, let's say we have 4 registers. When I erase one and save, it works. When I erase another and save, it works. When I erase a third one and save, it works. But, when there is just one register left, an ORA-01400 error comes out. "You cannot make an Null insert".

Any help please???

Thanks in advance!!!

Edited by: abladb on Sep 28, 2010 10:38 AM

Edited by: abladb on Sep 28, 2010 10:39 AM