> ... you're right ,
>
> but selecting the row with the mouse is not enough to identify the row ?

In my example, this would be equal to someone handing you two boxes
(the "left" and "right" box on the shelf) in random order. You select
a random box (by using your mouse ;) ... now, which one are you trying
to modify?

Heck, if you can't tell, how can you expect the guy (Firebird) to modify
one if it cannot tell which one of the two you got (your two rows in the
grid) was which box on the shelf?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

>
>
>
>
> > 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

> way
> > 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
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>
>
>
>
> --------------------------------------------------------------------------

----

>
>
> 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]
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>