|
114 KB
Working as designed.
Execute Edit is designed to modify data in a table. Views do not normally allow you to modified data. For some databases execute edit will popup the data and allow you to modify it; perhaps only oracle. Some databases will allow you to pop up the data and not allow you to modify the data. This will happen when the catalog tables contain tables and views together and those the object will be found and we proceed. Most databases will not allow you to execute edit on a view if the catalog tables separate the tables and views object info into different tables because we are only looking for tables and synonyms when we use the execute edit.
If my description does not help perhaps tariq can explain this in more details...
Ok. Looks like as a customer request we added execute edit on views from the tree node, but never from query analyzer. Will change issue to a feature request and move to future version. Will reassigned to sachin for prioritization...
Ok. Looks like as a customer request we added execute edit on views from the tree node, but never from query analyzer. Will change issue to a feature request and move to future version. Will reassigned to sachin for prioritization...
Issue #12263 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
Working as designed.
Execute Edit is designed to modify data in a table. Views do not normally allow you to modified data. For some databases execute edit will popup the data and allow you to modify it; perhaps only oracle. Some databases will allow you to pop up the data and not allow you to modify the data. This will happen when the catalog tables contain tables and views together and those the object will be found and we proceed. Most databases will not allow you to execute edit on a view if the catalog tables separate the tables and views object info into different tables because we are only looking for tables and synonyms when we use the execute edit.
If my description does not help perhaps tariq can explain this in more details...