auto-complete not refreshing changes
Posted: 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
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