hi,
working on forms 6i ,
i have a table with a composite primary key (quote_id , item_id , expiry_date ) , and a form with a block based on this table ,
i insert data normally into database through the block , but the problem appears when i try to update the records inserted , i face the error " unique constraint violated " .
- when i look at the database , i see no duplicate records at all ,
i deleted all records in the table , and created two new rows with different ( quote_id , item_id , expiry_date ) , it inserts , but the problem appears when update .
any idea ?