Page 1 of 1

auto-complete not refreshing changes

Posted: Mon 29 Jul 2013 08:29
by m.trigwell
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

Re: auto-complete not refreshing changes

Posted: Tue 30 Jul 2013 10:02
by .jp
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.