Subject Re: [firebird-support] Error : "There is at least one record with same fields values "
Author Martijn Tonies
> i have an error message i never had before , using Firebird 1.5 with
IBExpert :
> table has not index nor foreign keys nor constraints and i have two rows
with the
> same values , when i try to cancel or update one of them the message says
> "Cannot Post Changes . There is at least one record with same fields
values " .
> Ok , it is not a safe situation having two similar rows , but there is any
> to avoid that control , or edit that rows ?

This error comes from IBExpert, not from Firebird.

Without a proper way to identify the row, how do you expect IBExpert to
update the "right" one?

Imagine a shelf with 2 packages of cereal on them, you want to modify one
of them (take some cereal from it). Now, someone hands you over the
packages (you cannot see the shelf) and you want to "modify" the one that
was on the left. Which of these packages are you going to modify?

You can't tell, can you? :-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!