try using the rdb$db_key for this problem. just don't rely on it as a
long term key since it changes after a backup/restore cycle I think.

-steve

Tiago Mikhael Pastorello Freire wrote:

>
> Dear all,
>
> I have this table which stores the values of a looong questionnaire,
> and there
> are some duplicated entries. There are some complications. It was not
> developed by me, and it was rushed online. The genius has not created a
> primary key or any constraint to define the records by their
> uniquenes, nad
> thus we have a few exact duplicate rows which I should delete all but
> one.
> can someone spare me a bit of magic code to delete the duplicated
> entries and
> leave only one record?
>
>