Then, as the documentation states, you cannot edit the fields in that particular query. Either the table is read-only, you have multiple tables (like a join) in your SQL string, or you have functions (max(),min(),count()) in your string.
Check out those items again, and if you still can't edit it, post your SQL query and your CREATE TABLE statement so that we (the list) can test this out for you. J.R. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 24, 2006 11:42 AM To: J.R. Bullington; mysql@lists.mysql.com Subject: Re: mysql query browser- editing resultsets The edit button is 'greyed out' Ross ----- Original Message ----- From: "J.R. Bullington" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Monday, April 24, 2006 4:20 PM Subject: RE: mysql query browser- editing resultsets > There is an EDIT button on the bottom of the Query Browser. You have to > "activate" the edit feature by clicking on this. You will see that it > remains highlighted. > > To edit your cells, double click on them. When finished, hit APPLY CHANGES > at the bottom. If you do not apply them, they will not commit. > > J.R. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Monday, April 24, 2006 11:14 AM > To: mysql@lists.mysql.com > Subject: mysql query browser- editing resultsets > > Can someone explain to me how to edit this...I click on the cells and > nothing > > >>From the manual > > If the query resultset is editable, you can click the Edit button below > the > resultset view. Double clicking cells in the resultset will allow you to > edit their contents. Changes are commited to the database only after the > Apply Changes button is pressed. > For a resultset to be editable, the following conditions must be met: > > a.. the resultset must contain columns from no more than one single > table; > b.. the queried columns must be proper column names (e.g: no functions, > such as in SELECT max(price) FROM products); > > c.. this table must contain a Primary Key column, although not > necessarily > in the query. If the query does not contain the primary key, it will be > automatically added before the MySQL Query Browser sends the query to the > MySQL server, but will display only the columns you requested; > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
