I think the most likely case is the table is read-only. How do I change
this?
Ross
----- Original Message -----
From: "J.R. Bullington" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Monday, April 24, 2006 4:46 PM
Subject: RE: mysql query browser- editing resultsets
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
