Edit result set of a query with JOIN
Data Editor with allow to edit result set of a SELECT statement containing JOIN clause.
Data Editor toolbar will contain a combo-box that allows to chose table to edit. This table columns are highlighted and all other columns are grayed.
![](https://secure.gravatar.com/avatar/889a58fe2f34e9de84fc98d3305fe358?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)
Will be included in the next release
-
LSTemp commented
2Alex:
1) NN "each time when you need to edit data".views & grants for this. DB designer MUST make set of views for users: admin, user, master etc. if subj owner can't - then NN - simple. if it DB desiner - need hard work with self mind & hand. it all. and simple also.
2) "Sometimes you need to edit data of the query that you have copy-pasted from your code.?
say me 1 (ONE) engine what can enable it? SQL standard define updateable views (SELECT statement in this case same VIEW statement).
-
LSTemp commented
OOO.
1) since engine
1a) i want too ))
2) since engine ) view, grants & more more more -
AdminAlex Serdyuk (Admin, Devart) commented
Everything can be done by hands, but it's not convenient to create a view each time when you need to edit data.
Sometimes you need to edit data of the query that you have copy-pasted from your code. -
LSTemp commented
more: your can have SELECT GRANTS for tables in JOIN , but not UPDATE for some tables/fields. another task?
-
LSTemp commented
create updateable views instead & use it. here mysql restirictions. it can be resolve by client-side, but dont think what it is first task.