Re: dbext oracle connection under windows xp
- On Sat, Jan 10, 2009 at 5:06 PM, krzysztof cierpisz <ciapecki@...> wrote:
> Just pulled the new version and it rocks.
> One question to the completion feature.Yes and no.
> After pulling all column names into vim dictionary with <leader>slc
> is it possible to use them in SELECT (or other) part for columns
> Or the only way is to paste all of them, and delete the ones you don't
When you run a <Leader>slc (SQL List Columns), it fills the @"
register with the column list.
Then you just hit p to paste it into the buffer.
That is using pure dbext.
But, Vim also ships with autoload/sqlcomplete.vim.
It is a filetype based SQL omni completion plugin (which I also wrote).
It has it's own features outside of dbext.
If you have dbext installed, it uses dbext to retrieve database
information and it provides the completion you are looking for in this
:h sql-completion or
Without dbext, sqlcomplete can complete everything that Vim knows how
to syntax highlight. So keywords, datatypes and so on.
If you have dbext installed, then it can complete:
It is triggered by <C-C> and a letter.
<C-C>t - tables
<C-C>p - procedures
<C-C>v - views
<C-C>c - columns
There are a few more features to it on the Windows platform <C-LEFT>,
<C-RIGHT> when the completions are displayed. It allows you to drill
in and out of tables and columns. Great for trying to find the column
you were looking for.
This feature is only available on Windows since you cannot map
<C-LEFT> and <C-Right> on *nix.
There are many other features to it.
But specific to your question, you may also want to look at <C-C>l and <C-C>L.
So anyway, start with the tutorial and see what it can do for you.
You received this message from the "vim_use" maillist.
For more information, visit http://www.vim.org/maillist.php