Menu

#1 SUBQuery Collapse

open
nobody
5
2008-02-29
2008-02-29
Anonymous
No

This is pure gravy on top of an already excellent utility ...

But the ability to collapse parenthesis within a query string when writing would be great.

ie. Suppose you have:
SELECT * FROM EMPLOYEES WHERE EMPLOYEEID IN (SELECT EMPLOYEEID FROM PERFORMANCEMETRICS WHERE PF < (SELECT AVG(PF) FROM PERFORMANCEMETRICS))

ie. You could double-click on a (SELECT and it would remove that subquery and replace it with <SQ001> or something ... Double Click on <SQ001> again and it'd put it back.

Just a thought.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.