Beta 6.0 - Code suggestions in update not showing tables

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
mpogonowski
Posts: 4
Joined: Thu 14 Mar 2013 00:00

Beta 6.0 - Code suggestions in update not showing tables

Post by mpogonowski » Thu 14 Mar 2013 00:09

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]

alexa

Re: Beta 6.0 - Code suggestions in update not showing tables

Post by alexa » Thu 14 Mar 2013 16:57

We are currently investigating this issue and will answer you as soon as possible.

mpogonowski
Posts: 4
Joined: Thu 14 Mar 2013 00:00

Re: Beta 6.0 - Code suggestions in update not showing tables

Post by mpogonowski » Thu 14 Mar 2013 21:16

No worries! Just wanted to make you guys aware is all... I'll just use version 5 for writing procedures for now.

alexa

Re: Beta 6.0 - Code suggestions in update not showing tables

Post by alexa » Fri 15 Mar 2013 09:11

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.

mpogonowski
Posts: 4
Joined: Thu 14 Mar 2013 00:00

Re: Beta 6.0 - Code suggestions in update not showing tables

Post by mpogonowski » Sun 17 Mar 2013 21:26

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.

alexa

Re: Beta 6.0 - Code suggestions in update not showing tables

Post by alexa » Mon 18 Mar 2013 09:24

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?

mpogonowski
Posts: 4
Joined: Thu 14 Mar 2013 00:00

Re: Beta 6.0 - Code suggestions in update not showing tables

Post by mpogonowski » Tue 19 Mar 2013 22:21

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.

alexa

Re: Beta 6.0 - Code suggestions in update not showing tables

Post by alexa » Wed 20 Mar 2013 11:00

Please let us know if any questions arise.

Post Reply