Bug #6407 Row level editing disabled
Submitted: 3 Nov 2004 17:09 Modified: 3 Nov 2004 18:16
Reporter: Mr Wakazula Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.0 gamma OS:Windows (WinXP SP2)
Assigned to: Michael G. Zinner CPU Architecture:Any

[3 Nov 2004 17:09] Mr Wakazula 
Description:
Unable to perform row level editing via the Query Browser.

How to repeat:
1. enter query
SELECT * FROM table where field_id = 1

--OR--

SELECT * FROM table

2. Execute query

3. Edit button is always disabled; cannot perform row level editing
[3 Nov 2004 17:19] Michael G. Zinner 
Does the table you are selecting from has a primary key? Until the server gets support for client side cursors we have to relay on a primary key.

If the table has no primary key, it is read only.

Please verify if your table has a primary key. If it has not, please add one. If editing works, please state here.

Thanks!
[3 Nov 2004 18:03] Mr Wakazula 
Table only has a foreign key.

Under the context of your previous comment it makes sense why I cannot go into 'Edit' mode.

Thanks for the insight.