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 122416

Summary: Visual SQL Editor support for adding/deleting/modifying data
Product: obsolete Reporter: Troy Giunipero <tgiunipero>
Component: visualwebAssignee: David Vancouvering <davidvc>
Status: NEW ---    
Severity: blocker CC: romanmostyka
Priority: P3    
Version: 6.x   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Exception Reporter:
Bug Depends on:    
Bug Blocks: 152870    

Description Troy Giunipero 2007-11-20 18:08:41 UTC
This issue relates to the Visual SQL Editor in NetBeans 6.0. I am using NB 6.0 RC1.

If you input any query that doesn't begin with "SELECT", you get a Parse Error:  
"Encountered "[---]" at line 1, col 1.  Was expecting "SELECT"."  

The Editor doesn't expect any command other than "SELECT"?  How does the Visual SQL
Editor allow users to add/modify/delete data?
Comment 1 Troy Giunipero 2007-11-20 18:28:32 UTC
If you click Continue following a Parse Error msg, all three panes (Diagram, Grid, 
and Results panes) go blank, giving no indication of whether the query was successful or
not.  Why doesn't the Results pane at least give some sort of output?  In order for a 
user to verify the results, s/he has to perform a new SELECT query.

Comment 2 Petr Blaha 2008-11-18 13:22:37 UTC
Move visualsqleditor subcomponents below visualweb