On Sun, Mar 20, 2011 at 2:15 AM, Marc Delisle marc@infomarc.info wrote:
Le 2011-03-19 16:42, rohit sharma a écrit :
On Sun, Mar 20, 2011 at 2:03 AM, Marc Delisle marc@infomarc.info
wrote:
Le 2011-03-19 16:21, rohit sharma a écrit :
On Sun, Mar 20, 2011 at 1:45 AM, Marc Delisle marc@infomarc.info
wrote:
Hi, by default, the ShowSQL directive is true, which makes the generated
SQL
appear on top for almost every action. This fulfills many needs:
- people teaching SQL
- user who wants to verify what phpMyAdmin did in the backend
However with Inline edit, we no longer see this generated SQL and I'm wondering if something should be done about this.
Hi,
We can add a field for the last inline_edit query run by the user, and display it using a show/hide button. This field can be added just
beneath
the "generatedSQL" which is always displayed.
Hi, in the case of Edit, there is no Show/hide because the interface respects the $cfg['ShowSQL'] directive, so why should there be a Show/hide in the case of Inline Edit?
Hi,
In case of Edit, the query tends to be small, "select * from table_name;
"
(talking generally, although the query can be much longer) , and on the other hand inline-edit queries are update queries which can be quite long for tables with more columns, hence it would take away some valuable
space
from the displayed table.
I'm not sure I follow you. If you browse a table, click Edit on some row and make a change, you'll see the generated UPDATE statement, followed by a SELECT representing your current results set.
-- Marc Delisle http://infomarc.info
Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi,
Thanks. I got the idea. But in the case of "inline_edit" the query is being sent using Ajax, and the frame won't move after a query execution, so where do your propose to display the inline_edit query that was last run, so that the user gets notified.
-- Regards
Rohit Sharma CSE IIIT-Hyderabad http://iiit.net/