After I select and run a few lines, for some reason, Studio Express 16.10 deletes the rest of the script and only keeps the lines I run. I have to use command+z to get the rest of the script back. This is a pain, as I could lose the entire script. Has anyone else run into the same issue? I am using a Mac. Thanks.
Oh good, I'm glad it isn't just me! I assumed that I had inadvertently highlighted too much code.
This only started happening today and the only thing that (I think!) I've changed is to turn on the display of line numbers in the SQL Editor window. I'm running on Windows 7.
Could you please confirm theStudio Express Version. If you are using 16.10, Please test with 16.10.01 Studio Express build and let us know the result
Thanks for the idea. I'm using Studio (not Studio Express). Does this idea apply to my situation as well?
I have experienced it as well, with the Studio full version, not express....
seems to be especially (maybe only?) if the statement is DDL instead of DML?
It applies to both Studio and Studio Express. Could you please test with 16.10.01 build for both Studio and Studio Express
Are you running 'Execute as Individual' or F5? Can you try 'Execute Selected Text' which is a right click option? I notice if I have multiple SQL statements, it will remove the newline.
I think you might have got the (or maybe some) circumstances right.
I have downloaded Studio (full, not Express) 220.127.116.11708101349 (32-bit). The following steps re-create the problem.
Note that if I choose "execute selected text (alt+x)" then the sql editor still contains all of my sql, but the number of lines (of text) in the editor are reduced. I don't seem to lose any code but it has changed. How it changes is altered by which lines in the editor are highlighted.
See screen shots below.
The above is running the 32-bit version of TD Studio o Windows 7 (x64).