Subject Re: [firebird-support] Error : "There is at least one record with same fields values "
Author Maurizio P.
... you're right ,

but selecting the row with the mouse is not enough to identify the row ?

----- Original Message -----
From: Martijn Tonies
Sent: Monday, September 25, 2006 4:25 PM
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 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!


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.8/455 - Release Date: 22/09/2006

[Non-text portions of this message have been removed]