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