Bug Report: SQL Window

[ScottMattes]

I am sitting there staring at a query which takes up more than just a window, so there is a vertical scroll bar present.

I am looking at the top of the query, my hands are not on the mouse or keyboard, and suddenly the display changes to the bottom of the query!

I suppect some sort of timer driven event, but what? Can I control this with some setting, or do you have to change some code?

Thank you

 

[mike]

This happens to me too for packages as well. I don't know, but I have always assumed that when the backup happens, it positions the cursor back on the screen if I'm scrolled to a different location than my cursor is.

 

[Marco Kalter]

I cannot reproduce this. Do you have the time-based backup option enabled as suggested by mike?

 

[ScottMattes]

Do you mean Autosave Desktop? Yes, I do.

 

[ScottMattes]

OK, what Mike was seeing is what I am seeing (not only was I looking at the bottom of the SQL Window but the cursor was actually up at the top and had been scrolled off the screen).

I'd like the autosave feature to leave the screen alone.

Thank you.

 

[Marco Kalter]

It's not the AutoSave Desktop option, but the "Save time interval" of the "Recovery" section on the "Files/Backup" page of the preferences. Can you check this?

 

[ScottMattes]

Mine is set to 'save on time interval' which I have set to 3 minutes.

 

[Marco Kalter]

Can you disable to to see if this affects the problem?

 

[mike]

I can't reliably reproduce the error either and it doesn't happen every day. It does happen ocasionaly for me though. Next time it happens, I'll look to see if there is a pattern.

 

[ScottMattes]

Marco,
I turned it off, opened an SQL Window, typed a query, resized the window so that part was not visible, left the cursor on the first line and moved the scroll thumb to show the last half and let it sit. Nothing happned for many minutes (OK, 3 or 4 minutes).

I turned it back on, clicked OK and the SQL Window immeditately changed from showing the last part to showing the top.

 

[mike]

I've been playing with this a bit. In the program window, it doesn't consistently do this. It happened yesterday in a program window while I was scrolling, but I couldn't reproduce it.

I can always get it to do this in a SQL window though just like Scott said. I put my auto backup time to 1 minute. I changed a program window with about 600 lines to be a SQL window so I would have enough text since I didn't have SQL that long. It jumped back to the cursor position every minute.

I turned off all of my plug-ins and it still does it. I don't know if it matters, but my backup preferences are:
Save in absolute path
No save on execute
Save on time interval 1 minute (for this test; normally it's 10 minutes.)