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:	visualweb	Assignee:	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