1) Write any simple select query
2) Under Query menu options go to execute edit and click on it.
3) From pop up window select record(s) and say delete selected record(s).
4) It will neither delete any row from grid nor it will give any message saying that record has been deleted or not.
same is applicable for ADS 12
|
161 KB
|
205 KB
|
35 KB
|
36 KB
|
47 KB
|
38 KB
To work with the Execute Edit :
1. Select the rows to delete - the rows will change color
2. Next select a primary key
3. Priview the SQL in the Preview Tab
4.Next use the options under File -> Save and Refresh or Save and Close which will complete the delete.
See attached screenshots 1, 2, 3 and 4
Delete Selected Rows wont dynamically delete, you need to select a primary key if it is not present and Save the script to complete the operation.
Rohit, you can find documentation on Table Data Editor here :
Rohit, you can find documentation on Table Data Editor here :
Issue #8156 |
Closed |
Invalid |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
To work with the Execute Edit :
1. Select the rows to delete - the rows will change color
2. Next select a primary key
3. Priview the SQL in the Preview Tab
4.Next use the options under File -> Save and Refresh or Save and Close which will complete the delete.
See attached screenshots 1, 2, 3 and 4
Delete Selected Rows wont dynamically delete, you need to select a primary key if it is not present and Save the script to complete the operation.