Constraint error on key commit.

[munee]

Hi All,

I have created a form on a table. The table has a primary key.

On KEY-COMMIT on form level, I have written my own insert statement to insert record instead of using default commit.

I get constraint error (unique constraint violated).

I removed the Primary key and noticed that two records are getting inserted.. one is deafult by oracle, second because of insert statement on key commit.

I am confused.. Why should oracle use its default commit if I write something on key commit.

Thanks in advanvce for help

 

[sem]

Forms doesn't use its original COMMIT procedure, but rather INSERT one. You should place your trigger code into ON-INSERT trigger.

 

[munee]

I resolved this. Thanks for help sem.