In this case, the result set is not editable. It needs to have some way to uniquely identify the row(s) under edit so it can perform an update.
Tim -----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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
