I thought the RDB$DB_KEY was unique to each row? Could this not be
used to identify the row for deletion?

Rick


--- In firebird-support@yahoogroups.com, "kapilpatil84firebird"
<kapilpatil84firebird@y...> wrote:

>
> We Normally provide PRIMARY KEY in every Table.
> But Sometimes we forget or for some reason we do not provide

primary

> key in table.
> In that case it is very difficult to delete one of the two

duplicate

> records
>
> Just an Example:
> ======================================
> DEPT_ID DEPT_NAME
> 10 CHEMICAL
> 10 CHEMICAL
> 10 CHEMICAL
> ======================================
>
> Here I Entered Three duplicate records my mistake and I want to

keep

> only One Unique Record, So if would have been Any Feature to

Uniquely

> Identify the Row I would be able to Delete that row using that

UNIQUE

> ID as Oracle Supports.
>
>
> --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> <m.tonies@u...> wrote:
> >
> > Would you mind not writing "??? HELP--> " in every subject line.
> > This is a support list, we understand you want help.
> >
> > > In Oracle we have rowid which gives the unique id for each row
> > >
> > > Is There any feature in Firebird to get the unique id...
> >
> > No, not really.
> >
> > Is there any specific reason why you want to do this?
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle

&

> MS SQL
> > Server
> > Upscene Productions
> > http://www.upscene.com
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
> >
>