Subject Re: [firebird-support] Error : "There is at least one record with same fields values "
Author Martijn Tonies
> M> I know about RDB$DB_KEY -- but I'm not sure if IBExpert uses it.
> according to the OP, it appears it doesn't.
> M> Either way, the db_key is a trick that only (and not always) works with
> M> Firebird.
> I think it works with all databases supported by IBExpert. :-) And, in the
> scenario we're talking about (a simple view on a single table's data)
> it works and always has, both in IB and Fb.
> M> With any SQL-based database, you work with resultsets (or, in my
> M> a few boxes take from a shelf (= table) and brought to you). If you do
> M> have some way to uniquely identify them, you're screwed, db_key or not.
> M> Better have a PK column some way or another.
> No question about the above. You argued that IBExpert has no way to allow
> the user to delete a row in the described case, I just said it does
> and IMHO it should. Not that it matters much to me: I define PK-less
> tables about once in a couple years and I'm not an IBExpert user
> anyway. :-)

Yes, the db_key could/should work in this case...

I agree.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!