Subject Re: [firebird-support] Error : "There is at least one record with same fields values "
Author Nando Dessena

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 example,
M> a few boxes take from a shelf (= table) and brought to you). If you do not
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. :-)

Nando Dessena
I support Firebird, I am a Firebird Foundation member!
Join today at