On Tue, 2007-05-29 at 14:21 +1000, Stephen Gray wrote:
> Hi everyone,
>
> Just a request. There is a bug in Query Browser which means Edit button
> is greyed out for tables which have no primary key, so you can't
> add/edit records. I've seen a number of posts discussing this bug but it
> seems not to have been fixed in the latest version. Could this be fixed?
I think the standard answer here will be that this is not a bug; it's a
feature. If you don't have a primary key, how does Query Browser ( or
anything else ) know which row to update? The secret here is that it
*doesn't*, as it has no unique identifier to say, for example:
update _table_ set field = 'blah' where _unique_id = 'xxx';
You see, without the unique id bit, you'll update everything in the
table:
update _table_ set field = 'blah'
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@stripped
website: http://www.nusconsulting.com.au
