Bug #472 Cannot edit fields in MySQLCC when not selecting *

• Submitted: 21 May 2003 8:40
• Modified: 21 May 2003 8:57
• Reporter: Ron Fitzgerald
• Status: Closed
• Category: MySQLCC
• Severity: S3 (Non-critical)
• Version: 0.9.x
• OS: Windows (Windows 2000 Server)
• CPU Architecture: Any

[21 May 2003 8:40] Ron Fitzgerald

Description:
When selecting certain fields in your query, you cannot edit those fields.
example:
- SELECT pID, pdate FROM `p_field` -
The above does not allow to edit fields in query window as where
this does allow fields to be edited:
- SELECT * FROM `p_field` -

This is not a critical issue. It simply means you have to select all fields
if you want to edit one of them.

How to repeat:
1.) Open MySQL CC
2.) connect to database
3.) highlight any table
4.) click on 'sql' tool button to bring up sql pane (F2)
5.) select specific fields in your query
6.) run query
7.) attempt to edit fields - here is the problem -
8.) clear query
9.) replace your fields that you want to select with *
10.) run query
11.) you now can edit your fields

Suggested fix:
Unknown

[21 May 2003 8:57] Jorge del Conde

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Hi!

This is the expected behaviour for MySQLCC V1 ... this will change as soon as new features (cursors) are added to MySQL.