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 180643 - MySql query builder / code completion function.
Summary: MySql query builder / code completion function.
Status: RESOLVED INCOMPLETE
Alias: None
Product: db
Classification: Unclassified
Component: MySQL (show other bugs)
Version: 6.x
Hardware: PC Windows XP
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-02-11 20:50 UTC by CityBeekeeper
Modified: 2010-03-17 13:32 UTC (History)
0 users

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 CityBeekeeper 2010-02-11 20:50:39 UTC 
I'm looking for a new IDE and evaluating NetBeans 6.8.

I tried to use the MySql query builder function and failed, so I've created a new installation and imported a couple of table structures from an old application.
I used the defaults this time and used WAMP.
This is what I've found:

1st Ctrl+space gives the option to select the connection if it's not been selected before.  Then selected and pressing "enter" adds the database name to the code, so I deleted that and then got the table.

I have to add FROM <table(s)> and then go back before the FROM before the MySql query builder code completion or query builder showed the columns. 

It would be nice be able to select multiple columns at the same time.

I had to restart the IDE to use a table added externally whilst the IDE was open.

Gregory.

PS.  I have searched for this bug but the search stalled at the "Please stand by ..." stage, so I've entered this.
Comment 1 Jiri Rechtacek 2010-03-17 13:32:23 UTC 
Please, could you describe your problem again? I don't know what MySQL Query Builder means, DB tooling in IDE hasn't had such feature. Did you install it from NetBeans Plugins? Provide more details about the problem - a screenshot, step-by-step how to reproduce it, ... Thanks