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 113494 - Query Editor: SQL statement "select..." isn't appear after using "insert..."
Summary: Query Editor: SQL statement "select..." isn't appear after using "insert..."
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: John Baker
URL:
Keywords:
Depends on:
Blocks: 152776
  Show dependency tree
 
Reported: 2007-08-22 13:31 UTC by _ alexpetrov
Modified: 2009-05-25 21:07 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 _ alexpetrov 2007-08-22 13:31:28 UTC 
Product Version: NetBeans IDE Dev (Build 200708200000) 
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 popup menu item "Design Query..." for DB table "TRIPTYPE".
3. In the SQL Pane of the opened Query Editor:
   - change SQL statement "SELECT..." to SQL statement "INSERT...":
     insert into "TRAVEL"."TRIPTYPE" 
     ("TRAVEL"."TRIPTYPE"."TRIPTYPEID", "TRAVEL"."TRIPTYPE"."NAME", "TRAVEL"."TRIPTYPE"."DESCRIPTION") 
     values (101, 'New_TripType', 'New_TripType')
   - right click and select popup menu item "Run Query", click "Continue"
4. In the Table Diagram Pane right click and select popup menu item "Add Table..."
   In the appeared dialog select TRAVEL.TRIPTYPE and click "OK".
5. In the table diagram "TRIPTYPE" unmark all checkboxes-columns and mark them again.

Result:
- it's impossible to unmark/mark checkboxes "Output" in the Table Pane, but in the Diagram Pane
  all checkboxes could be marked/unmarked

- SQL statement "insert..." will be still shown in the SQL Pane and 
  the appropriate statement "select..." will not appear
Comment 1 Andrei Badea 2007-10-09 15:34:07 UTC 
Reproducible. The Add Table action should not be enabled if the statement in the editor is not parsable.
Comment 2 Petr Blaha 2008-11-18 13:01:11 UTC 
Move visualsqleditor subcomponents below visualweb