James

I'd like to second this request. Consider the situation where a table contains information about a customer's order, to show the customer name from a joined table with customers would be very useful however, as soon as I join a second table - the view immediatley becomes uneditable - regardless of whether I can edit it directly with sql. I'd suggest perhaps allowing a checkbox next to the fields that you want to edit, so that when you click modify you can change that one field - this will mean your...

I've performed an ugly work-around which might help someone in the future: function rowDescription($R){ foreach(fields($R) as $p){ if(preg_match("~varchar|character varying~",$p["type"])) { if ($p["field"] == 'chrFirstName') { return "CONCAT(chrFirstName,' ',chrLastName)"; } } } foreach(fields($R) as $p){ if(preg_match("~varchar|character varying~",$p["type"])) { return idf_escape($p["field"]); } } return""; }

I've performed an ugly work-around which might help someone in the future: function rowDescription($R){ foreach(fields($R) as $p){ if(preg_match("~varchar|character varying~",$p["type"])) { if ($p["field"] == 'chrFirstName') { return "CONCAT(chrFirstName,' ',chrLastName)"; } } } foreach(fields($R) as $p){ if(preg_match("~varchar|character varying~",$p["type"])) { return idf_escape($p["field"]); } } return""; }

Adminer Editor beautifully replaces foreign keys with the next column values from the foreign table to make more user friendly display, creation and editing forms. Consider a common table will split first name and last name into separate columns. When the foreign key is referenced only the first column will be used e.g. you'll have 100 Stevens when trying to select from the drop down list. This makes the drop downs for new or edit unusable and makes the display ambiguous. I've attempted to modify...

A work around seems to be to add permissions in the mysql.tables_priv table for the user to perform selects on mysql database, proc table.