|Subject||Re: [firebird-support] Error : "There is at least one record with same fields values "|
> i have an error message i never had before , using Firebird 1.5 withIBExpert :
> table has not index nor foreign keys nor constraints and i have two rowswith 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 fieldsvalues " .
> 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? :-)
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!