[Phpmyadmin-devel] Inline edit and UPDATE feedback

[Marc Delisle]

Le 2011-03-19 16:42, rohit sharma a écrit :
> On Sun, Mar 20, 2011 at 2:03 AM, Marc Delisle <marc at 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 at 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