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.
Alex Serdyuk
shared this idea
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.