Why can not I edit the results of a query in the SQL Editor?
Submitted by: AdministratorQuery statements MUST return the ROWID to be updatable. For example:
select * from employee where salary > 2000
would not be updatable, whereas:
select employee.*, rowid from employee where salary > 2000
would be updatable.
To reduce this obvious nuisance, you can use the TOAD-specific EDIT statement. For example:
edit employee where salary > 2000
If the resultset should be editable but remains read-only, make sure the TOAD Options > Data Grids - Data tab, Default to Read-Only Queries checkbox is NOT enabled
Submitted by: Administrator
select * from employee where salary > 2000
would not be updatable, whereas:
select employee.*, rowid from employee where salary > 2000
would be updatable.
To reduce this obvious nuisance, you can use the TOAD-specific EDIT statement. For example:
edit employee where salary > 2000
If the resultset should be editable but remains read-only, make sure the TOAD Options > Data Grids - Data tab, Default to Read-Only Queries checkbox is NOT enabled
Submitted by: Administrator
Read Online DataGrid (Grid view) Job Interview Questions And Answers
Top DataGrid (Grid view) Questions
☺ | Why can not I add an entry via the grid for a table containing a CLOB column? |
☺ | In DataGrid, is it possible to add rows one by one at runtime. That means after entering data in one row next row will be added? |
☺ | How can I view the Chinese and Japanese character sets through Toad? |
☺ | What is a DataGrid or Grid View? |
☺ | Why can not I add a new record by hitting the down arrow key in the data tab? |
Top Dot Net Technologies Categories
☺ | MSF Interview Questions. |
☺ | .Net Architecture Interview Questions. |
☺ | ASP.Net MVC Interview Questions. |
☺ | Entity Framework Interview Questions. |
☺ | C# (Sharp) Programming Language Interview Questions. |