|Subject||Re: [firebird-support] Error : "There is at least one record with same fields values "|
> M> Heck, if you can't tell, how can you expect the guy (Firebird) tomodify
> M> one if it cannot tell which one of the two you got (your two rows inthe
> M> grid) was which box on the shelf?I know about RDB$DB_KEY -- but I'm not sure if IBExpert uses it.
> well, the mouse example is not that wrong. I'd probably expect the guy
> (IBExpert) to use the RDB$DB_KEY to update the record. It's certainly
> what I'll expect FlameRobin to do when it will learn to update rows
> automatically. :-)
Either way, the db_key is a trick that only (and not always) works with
With any SQL-based database, you work with resultsets (or, in my example,
a few boxes take from a shelf (= table) and brought to you). If you do not
have some way to uniquely identify them, you're screwed, db_key or not.
Better have a PK column some way or another.
Database Workbench - development tool for Firebird and more!
Database development questions? Check the forum!