edit/delete multiple rows in search mode

[Former user]

Originally reported on Google Code with ID 216

When i click a table name, i get nice results with checkbox (to edit/del few or all)
and single edit/del.

when i search (Tab: SEARCH), my results are without checkbox, only single edit/del

and when i use sql statment (Tab: SQL), there are none of these options. i only can
see my results but cant edit/del

Any reason for this or we still didnt add these options?

Reported by teryaki1963 on 2013-05-17 12:06:31

[Christopher Kramer]

When you do an SQL statement, there is a reason why you don't have edit/delete buttons:
What you see might not be a real table, it might be joined across multiple tables,
aggregated, grouped data or stuff like this. It is impossible to edit such data.
Example query: SELECT AVG(e.salary) sal, d.department FROM employee e, department d
WHERE d.department = e.department GROUP BY e.department

You have 2 source tables in here, grouped data and aggregation on these groups. What
should happen to the source data if you edit the AVG column?


That said, for the search tab this argument does not really hold. There, you always
see data from only one table and there is no grouping or aggregation done, only filtering.
Having checkboxes there should be possible.

If we do this, we should have a look at the code. I think there is redundant code around
this.

Reported by crazy4chrissi on 2013-05-17 12:46:14

[Christopher Kramer]

For the reasons above, I reject the request to add edit/delete to SQL-tab results.

Therefore, the remaining issue is to add checkboxes in the search-results to be able
to delete/edit multiple rows. I accept this request and change the issue title accordingly.

Reported by crazy4chrissi on 2013-05-17 12:50:51 - Status changed: Accepted

[Former user]

Yep, you right, thx for the statement example

Adding checkbox for search results is enough.

Reported by teryaki1963 on 2013-05-17 13:06:44

[Former user]

Reported by dj.nandos on 2013-10-23 13:22:54

[Christopher Kramer]

I guess you posted the gmail icon by mistake? :D

Reported by crazy4chrissi on 2013-10-23 14:17:12

[phpLiteAdmin]

Solved with commit 4a3f7b68ef59ba4bd88e94f90530c287e551f842