add a distinct() method

rrzavaleta

Hi,

How could add a distinct () method within the editor to perform the query and not repeat fields.

Could you please give me some solution

rrzavaleta

to explain better I mean the mysql DISTINCT in their instruction .

SELECT DISTINCT
lastname
FROM employees
ORDER BY lastname

allan

Is this for the editable table? The problem you have there is that you would need to group by last name as well, since presumably every row has its own unique id. Then an update would need to edit all rows which match that id.

Editor currently doesn't support multi-row editing, but even when it does, due to the grouping complexity it is unlikely that it will operate quite in this manner.

Allan