auto-complete not refreshing changes

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
m.trigwell
Posts: 1
Joined: Mon 29 Jul 2013 08:15

auto-complete not refreshing changes

Post by m.trigwell » Mon 29 Jul 2013 08:29

Hi Guys,

I'm working with the stored procedure editor in dbForge which I am finding very easy and intuitive to use.

My only issue is that when I make a change to a field name in a database table, the name change is not picked up by the auto-complete in the editor.
I have tried refreshing the connection in the database explorer, but this does not update the auto-complete information. The only way to get it to pick up the changes is to completely exit the program and restart it again.

Example:
TABLE - tbl_hours
FIELD - end_time datetime DEFAULT NULL

Open the stored procedure editor and create a stored proc that uses the tbl_hours table.
Using the database explorer window, rename the field end_time to stop_time.
Go back to the stored procedure editor and try to use the field stop_time.
The stop_time field name is not appearing in the auto-complete list. end_time still remains.

Can this please be fixed or is there already a solution to this problem?

Thanks,

matt

.jp
Devart Team
Posts: 345
Joined: Wed 09 Sep 2009 06:55
Location: devart

Re: auto-complete not refreshing changes

Post by .jp » Tue 30 Jul 2013 10:02

After modification of server object, it is necessary to do Refresh Suggestion from the Edit -> Code Completion menu item, or by pressing the CTRL+SHIFT+R shortcut.

Post Reply