[
https://issues.apache.org/jira/browse/NETBEANS-189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17476237#comment-17476237
]
Eric Bresie commented on NETBEANS-189:
--------------------------------------
Testing includes:
# Starting netbeans
# Ensure No connections are yet established
# Create a new SQL FIleFile...New...Other..Sql File (set given filename)
# Edit SQL file. Type "SE" + "CTRL+Space" for auto completion of SELECT
# Attempt CTRL+Space => No Suggestions [this is as no connection established
yet]
# Complete basic select statement (i.e. SELECT * from SomD;)
# No connection selected yet.
# On select line, attempt to run
# Shows "No database connection is selected. Please select a connection in the
Connection combo box in the editor toolbar."
# Create a valid DB Connection in Database services pane to appliable DB.
# Select new DB Connection from Connection combo box
# Type new line with SELECT then attempt autocompletion. This will show
available DB schema based on the given connection to auto complete with.
# Once rest of select statement complete, attempt to run expression. Will show
resulting query results.
> SQL editor, shouldn't ask evertime to set the connection
> --------------------------------------------------------
>
> Key: NETBEANS-189
> URL: https://issues.apache.org/jira/browse/NETBEANS-189
> Project: NetBeans
> Issue Type: Improvement
> Components: db - SQL Editor
> Affects Versions: Next
> Reporter: Christian Lenz
> Assignee: Eric Bresie
> Priority: Major
> Labels: pull-request-available
> Attachments: SQL Notification.png, required-connection.gif
>
> Time Spent: 8h 40m
> Remaining Estimate: 0h
>
> Of course, the SQL editor doesn't make sense, if you don't set a connection
> to see databases, tables and columns, but sometimes or often, you only want
> to scratch a SQL query and you want the code completion for the SQL stuff,
> like the keywords (SELECT, FROM, WHERE) or aggregate functions (COUNT, AVG,
> etc.) So this is not possible, without setting a connection. But when I don't
> have a connection, I can't use the code completion, becauses it will ends up
> in a loop. See my little screen capture for what I mean.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
