db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject adding a record to a table
Date Sat, 15 Feb 2014 02:57:31 GMT
Hi

I have a table in which the key is the first two fields viz date and time
the last two records in the table are
2014-02-14      0   .......................
2014-02-14      6   ......................

When I try to add a new record

2014-02-14     12   ........................

I get Error code-1, SQL state 23505
Insert command failed: The statement was aborted because it would have
caused a duplicate key value in a unique or primary key constraint or unique
index indentified by 'SQL14021012215370' defined on 'table name'

What does this error mean ?



--
View this message in context: http://apache-database.10148.n7.nabble.com/adding-a-record-to-a-table-tp137120.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message