Have you tried adding rdb$db_key to your query (rdb$db_key always exists
and is unique within your current transaction)?

HTH,
Set

Maurizio P. wrote:

> 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 ?
>
> thank you
>
> Mauro .