Thank you, Jon.  I appreciate the response.  Some co-workers and I are trying to get our company to purchase some of your software.

I have just uploaded ViEmu/SQL 2.0.59 with the :run command implemented. Details and a link to download here:

  http://forums.ngedit.com/viewtopic.php?id=171

(Uninstall the previous version manually before installing this one)

Hello usr01,

If you enable the ViEmu setting "Use standard selection for visual mode" in Tools|ViEmu Settings, it should work like that right away - :run, or actually :'<,'>run which is what will show up, should execute the portion selected in visual mode.

In case you're not familiar with vim's visual mode, you enter it by pressing 'v' or 'V' (better use 'V' for linewise selection), you then move around to highlight the area, and type an operator that will operate on the highlighted area ('d' to delete, 'y' to yank, etc...). It's a great feature of vim. Ctrl-V enters it in column/block mode, which is very useful when editing column-oriented data.

Let me know if it doesn't work fine or more clarification is needed.

Regards,

  Jon

Hello,

You are right, the same happens in my installation. I hadn't even noticed the problem because (1) I tend to use Ctrl-F/Ctrl-B rather than Ctrl-D/Ctrl-U for page scrolling, and (2) because it doesn't happen when you are not connected to a database.

The problem is that 'unnamed' commands such as that one (it is apparent because it shows a number in the keybinding list, rather than a name such as Edit.Paste) cannot be programmatically unbound from their assignments.

I'll be investigating it in more detail to try to find a workaround and come back to you as soon as I have more information. I plan to implement a different keypress-interception method in the future (actually, just bringing the one I developed for ViEmu/Word&Outlook into the VS and SQL products) which would fix this, but that will definitely take some time - most likely a few months. I hope to find some workaround before that.

Meanwhile, you can use Ctrl-F/Ctrl-B for scrolling, and you can also map them to get half-page scrolling, by adding this to _viemurc in your user folder (typically C:\Documents and Settings\{username}):

nnoremap <c-f> <c-d>
nnoremap <c-b> <c-u>

Regards,

  Jon

There was good stuff in here about how to operate in Management Studio better. Using the "V" command to mark text is a good trick. I wonder if there was a way to make this even easier. One thing I like about Toad is that you can press the "execute current" key and it highlights the "current" statement which is assumed to be all the contiguous non-blank lines around the cursor.  This makes for a great time-saver when you are editing adhoc SQL which may contain many different multi-line statements. Any great suggestions on how to get a block like that quickly marked?

Stephen