How do we disable auto-refresh?

Hi,

In the Editor, I'd like to disable the feature that randomly refreshes a table or database.

Most of my sql sets the schema at the top, and I run the sql statements individually. But in the middle of either editing or doing something else entirely, the editor starts expanding the schema for a table that's referenced in the sql.

I would rather expand or refresh manually. What setting do we use for that?

It's not random. Do you see that happening when you execute DDL statements in the editor, like CREATE or DROP something?

Just in case, there is an option in Options -> DB Options -> [db type here] -> Automatic Cache Refresh, which controls sensing of CREATE and DROP commands and automatic refreshes.

I checked, Automatic Cache refresh is set to off.

It happens when I'm merely inside the Sql Editor, whether I'm editing some sql or just viewing it.

If I just execute sql and then exit the editor quickly enough, most of the time it doesn't happen at all. But if I'm in the editor long enough - whether or not I run anything - it will eventually try to refresh a schema.

Is it because the Database Explorer is open? Should I try to UnView the explorer when I'm just executing sql that doesn't require editing?

Something is triggering it. The database explorer does have an automatic refresh. But there is a manual refresh Ctrl+Shift+F8. Are you using that or perhaps customized the default key and accidentally replaced with something else more common?

Maybe. I'll take a look tomorrow, thanks.

	SysOp wrote:
	Something is triggering it. The database explorer does have an automatic refresh. But there is a manual refresh Ctrl+Shift+F8. Are you using that or perhaps customized the default key and accidentally replaced with something else more common?

No go on the reassigned hot key test.

This has been happening for a long time, so it's not important to resolve it right away.

Can I install Beta 13 simultaneously with 12? Will 13 inherit 12's settings? I'll see if 13 has the problem.

Installing 13 beta won't delete your existing settings, it will only rename files to have .old and .bak extensions. And yes, it will try to merge them with the new files.

You may want to create a backup of the existing folder with settings for 12, this one C:\Users\[user]\AppData\Roaming\SQL Assistant\12.4 folder before the installation, so you can later restore it if needed. But please don't restore them while running 13.

Will do, thanks Sysop.

SysOp wrote:

Installing 13 beta won't delete your existing settings, it will only rename files to have .old and .bak extensions. And yes, it will try to merge them with the new files.

You may want to create a backup of the existing folder with settings for 12, this one C:\Users\[user]\AppData\Roaming\SQL Assistant\12.4 folder before the installation, so you can later restore it if needed. But please don't restore them while running 13.

Could this be the syntax checker? It kicks off after a set interval (I think the default is 3 seconds)? Just a thought.

The background syntax checker is responsible for 3 things: checking for syntax errors, checking for query performance issues, and somewhat involved in refreshing the marks for TO-DO and bookmarks. It's unlikely to trigger anything else, certainly not directly.