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 - Visual SQL Editor support for adding/deleting/modifying data
Summary: Visual SQL Editor support for adding/deleting/modifying data
Status: NEW
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks: 152870
  Show dependency tree
 
Reported: 2007-11-20 18:08 UTC by Troy Giunipero
Modified: 2008-11-18 13:22 UTC (History)
1 user (show)

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 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