> 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. :-)

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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com