Toad World® Forums

CRUD bug


#1

There is a bug in getting the CRUD Matrix for a query. If you do the following:
SELECT * FROM DUAL;
Then click on the Insert CRUD Matrix button, you correctly get:
–±-------------------------------------±----+
–| OBJECT |SEL|
–±-------------------------------------±----+
–| DUAL | X |
–±-------------------------------------±----+

But, if your Select contains a CASE, you get no objects in the matrix:
SELECT (CASE WHEN 1 = 1 THEN 1 ELSE 2 END) x
FROM DUAL;
Then click on the Insert CRUD Matrix button, you get:
–±------------------------------------±-----+
–| OBJECT |SEL|
–±------------------------------------±-----+

Also, it would be nice if would work inside the pop-up matrix box to Select All to copy. Or, even nicer, add a Copy to Clipboard button.

Thanks.
-Charlie


#2

Hi Charlie,

Nice catch on “CASE”.
This has been introduced (9.# ?) since we last updated the Nav Functionality.
I’ve logged a CR to have this updated!!

I’ve logged a seperate CR for the other enhancement(s) re the <Ctrl+A> and copy to clipboard options (also good enhancements).

Thanks for your feedback!!
Jaime