This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 185452 - format query
Summary: format query
Status: RESOLVED DUPLICATE of bug 155167
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: -S1S-
Hardware: PC Windows XP
: P3 normal with 2 votes (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-05-04 16:18 UTC by nbphpuser
Modified: 2012-05-17 11:06 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description nbphpuser 2010-05-04 16:18:53 UTC 
It would be great if NB could format queries. 

If you copy paste some long query as one line it is difficult to edit and inspect it. Editor could make great job if it does some basic formating like below:


select a, b, c from sometable where a=1 order by b limit 1;

format into:

SELECT
 a, 
 b, 
 c 
FROM sometable 
WHERE a=1 
ORDER BY b 
LIMIT 1;
Comment 1 matthias42 2012-05-17 11:06:30 UTC 

*** This bug has been marked as a duplicate of bug 155167 ***