Re: Query Browser bug

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: [email protected]
website: http://www.nusconsulting.com.au


-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]