Beta 6.0 - Code suggestions in update not showing tables
-
- Posts: 4
- Joined: Thu 14 Mar 2013 00:00
Beta 6.0 - Code suggestions in update not showing tables
G'day,
I'm trying out your beta Version: 6.0.107, having previously purchased version 5.
When I'm typing code in either the SQL entry window, or a new procedure and I start with UPDATE, the code suggestions I'm receiving do not include the names of the tables in the database I'm using.
ie. in 5.0.97 I get [suggestions in brackets]
BEGIN
UPDATE t[table1; table2; etc]
in 6.0.107 I get
BEGIN
UPDATE t[test(database); alter database; alter event; etc]
I'm trying out your beta Version: 6.0.107, having previously purchased version 5.
When I'm typing code in either the SQL entry window, or a new procedure and I start with UPDATE, the code suggestions I'm receiving do not include the names of the tables in the database I'm using.
ie. in 5.0.97 I get [suggestions in brackets]
BEGIN
UPDATE t[table1; table2; etc]
in 6.0.107 I get
BEGIN
UPDATE t[test(database); alter database; alter event; etc]
Re: Beta 6.0 - Code suggestions in update not showing tables
We are currently investigating this issue and will answer you as soon as possible.
-
- Posts: 4
- Joined: Thu 14 Mar 2013 00:00
Re: Beta 6.0 - Code suggestions in update not showing tables
No worries! Just wanted to make you guys aware is all... I'll just use version 5 for writing procedures for now.
Re: Beta 6.0 - Code suggestions in update not showing tables
Since the Code Completion functionality was completely changed in the new version 6.0, the table names are now included in the suggestion list only in valid scripts. Therefore, the BEGIN...END block has to be used, inside, for example, the CREATE PROCEDURE statement but not on its own.
-
- Posts: 4
- Joined: Thu 14 Mar 2013 00:00
Re: Beta 6.0 - Code suggestions in update not showing tables
Fair call, I left those statements off my example but I was using them. The same problem also occurs in the SQL entry screen which doesn't require BEGIN ... END statements.
Re: Beta 6.0 - Code suggestions in update not showing tables
Could you please provide us the full script so we can reproduce this issue on our side?
Please also provide us the full version of dbForge Studio Beta for MySQL from the 'About dbForge Studio for MySQL' window (select 'Help -> About...' from the main menu) and the version of the MySQL server?
Please also provide us the full version of dbForge Studio Beta for MySQL from the 'About dbForge Studio for MySQL' window (select 'Help -> About...' from the main menu) and the version of the MySQL server?
-
- Posts: 4
- Joined: Thu 14 Mar 2013 00:00
Re: Beta 6.0 - Code suggestions in update not showing tables
Well I'll be, I must have been doing something screwy... I went back in to get a screenshot and it wasn't happening any more.
Apologies for the time-waste.
Apologies for the time-waste.
Re: Beta 6.0 - Code suggestions in update not showing tables
Please let us know if any questions arise.