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 111248 - QueryEditor: if all columns are deselected, SQL statement won't be updated by using Diagram pane
Summary: QueryEditor: if all columns are deselected, SQL statement won't be updated by...
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: PC All
: P4 blocker (vote)
Assignee: David Vancouvering
Depends on:
Blocks: 152776
  Show dependency tree
Reported: 2007-07-27 16:49 UTC by _ alexpetrov
Modified: 2008-11-18 13:04 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Note You need to log in before you can comment on or make changes to this bug.
Description _ alexpetrov 2007-07-27 16:49:39 UTC
Mac OS X, j2sdk 1.5.06, build 0707241200
Product Version: NetBeans IDE Dev (Build 200707270000) 
Java: 1.6.0_02; Java HotSpot(TM) Client VM 1.6.0_02-b06 System: 
Windows XP version 5.1 running on x86;

1. Connect to DB Derby Travel
2. Use poup menu item "Design Query..." on DB table "Person"
3. In the opened Query Editor deselect all DB table columns either in Diagram pane or in Columns pane.
- SQL pane still contains the clause FROM "TRAVEL"."PERSON"

4. In the SQL pane use popup menu item "Parse Query".
- Diagram pane and Columns pane will be empty.

5. In the Diagram pane use popup menu item "Add table", select TRAVEL.PERSON, click "OK".

- SQL pane won't be updated
- it's impossible to deselect/select any DB table columns in Diagram pane/Columns pane
Comment 1 John Baker 2008-01-12 05:54:09 UTC
If a query is incorrect then add table shouldn't be enabled.  This issue is covered by 113494

Even though "FROM TRAVEL.PERSON" isn't removed from the text pane, the query is still usable after enabling some columns
in the graph pane.

Lowering priority as this is minor issue
Comment 2 Petr Blaha 2008-11-18 13:04:36 UTC
Move visualsqleditor subcomponents below visualweb