autocmd error in vim
my .vimrc has the structure: Fortran stuff :let fortran_do_enddo=1 :let fortran_more_precise=1 :let fortran_free_source=1 :let fortran_have_tabs=1 autocmd BufNewFile *.f90 call New_Fortran_File() fun! New_Fortran_File() :0put='!This is file : ' . expand('%') :put='Implicit None' exe :3 endf which is working fine with gvim, but if I use vim, its giving error. The error prompt is coming in non f90 file also. as: $ vi i Error detected while processing /home/rudra/.vimrc: line 31: E488: Trailing characters: :0put='!This is file : ' . expand('%') line 32: E488: Trailing characters: :put='Implicit None' Press ENTER or type command to continue My vim is up-to-date $ vi --version VIM - Vi IMproved 7.3 (2010 Aug 15, compiled Aug 28 2012 13:51:59) Included patches: 1-415, 417-638 Does it mean vi(m) do not support autocmd? Or I am doing something wrong? Please help. If needed, I am posting my full vimrc: set autoindent set smartindent set hlsearch set incsearch set ignorecase set smartcase set novisualbell set paste set ruler set expandtab set smarttab set shiftwidth=3 set softtabstop=3 set mouse=a enable mouse set nu show line number set cul highlight current line if version = 700 set spell spl=en_us set nospell nmap F12 :set spell! endif Fortran stuff :let fortran_do_enddo=1 :let fortran_more_precise=1 :let fortran_free_source=1 :let fortran_have_tabs=1 autocmd BufNewFile *.f90 call New_Fortran_File() fun! New_Fortran_File() :0put='!This is file : ' . expand('%') :put='Implicit None' exe :3 endf filetype on filetype plugin on filetype indent on syntax enable latex only let g:tex_flavor='latex' Always jump to last edited line if has(autocmd) au BufReadPost * if line('\) 0 line('\) = line($) \| exe normal! g'\ | endif endif let g:Imap_UsePlaceHolders = 0 set sw=2 set iskeyword+=: -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: autocmd error in vim
Hello friends, You may ignore this post. This problem is solved once I installed vi-enhanced. I only had vi-minimal before. But both were showing vim as version. -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Colorschemes and split window
On Saturday, September 22, 2012 1:18:23 AM UTC-5, ramgorur wrote: H On Monday, April 30, 2012 9:15:26 AM UTC-4, rameo wrote: It seems that I have found the solution (after many many hours of trying :-( ) I created the function below. The function must do this (and seems to do it): a) when there is only 1 window: check if filetype is vim -- Dark_ColorScheme if filetype is not vim -- Light_ColorScheme b) when there is a split window: check if exist split window colorscheme variable (g:splitcolor) if yes, colorscheme of splitwindow = g:splitcolor when leaving split window: keep the value of the current color in g:splitcolor Can anyone tell me if I made a mistake and if the function can be simplified? function SetColors() if winnr('$') 1 if exists('g:splitcolor') exe 'colors '.g:splitcolor else exe 'colors Light_ColorScheme' endif elseif winnr('$') == 1 ft == 'vim' exe 'colors Dark_ColorScheme' elseif winnr('$') == 1 ft != 'vim' exe 'colors Light_ColorScheme' endif endfunction function KeepColors() if winnr('$') 1 let g:splitcolor = g:colors_name endif endfunction augroup filetype_colorscheme au BufEnter * call SetColors() au BufLeave * call KeepColors() augroup END Hi, I am trying to achieve similar goal, I want to have different color schemes for different file types, but I use omnicppcomplete, which opens a floating window for auto-completion. So, when I try to do the autocompletion, the whole color scheme reverts back to the default. Have you found any work around? What do you mean by floating window? The best workaround would probably be to detect this type of window in your function and take no action if detected. Is it just the preview window? If so, testing for previewwindow should do it. Does it have a special buftype value? Or a special filetype value? These could be tested as well. I suspect you're talking about the preview window, since you're using completion. If you have preview in your 'completeopts' option, you will automatically see the preview window pop up for completion methods which supply the required information. -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: [msza...@gmail.com: Re: a small plugin for :call system() in vim]
On Friday, September 21, 2012 8:59:39 PM UTC-5, Gary Johnson wrote: I also found that :echo system('... works well on Windows: it avoids the new Command Prompt window when using gvim If only! If you pay close attention or run a command which takes long enough you will see the command window flash briefly. I guess it immediately disappears without asking you to press enter to continue, which is nice, but still lets you see the output unlike using :!start. -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: vim tabs nd ctrl-pgdn not working on cygwin cmd shell
On Friday, September 21, 2012 3:56:06 AM UTC-5, Gelonida N wrote: I'm running vim on multiple platforms. I wanted o see whether vim tabs may be something useful for my way of working. On most of my platforms I can use 'CTRL-Pgdn' to change tabs However this is not working on cygwin if started from a cmd (or an rxvt-native) windows If I start vim (not gvim) in an xterm CTRL-PgDn is working However in a cmd shell this keyboard combination seems to be ignored. Is Windows catching this combination? If yes, can I convince it to leave my cmd window alone? As I change platforms / workstations often not having the same keyboard shortcuts on all machines makes a feature much less attractive. I'd recommend using gt and gT instead of C-PageDown and C-PageUp. They are synonyms, easier to type, and will work on all platforms without trouble and without any additional mappings. -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Split windows and syntax highlighting
Hi there! Is it somehow possible to do a :syn off only for one specific window? Thanks in advance! -- Matthias -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Vim for Oracle
HI All, I am an enthusiastic vim fan but never used it much .I use sqldeveloper for db related tasks.Due you guys really feel comfortable in vim to write pl/sql and also can you guys also query the db and see the resutlset through vim. -- *Thanks Regards Vickyb * -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
Hi Vicky, Yes to both questions. If you download the dbext script from the vim.org site you can access and view the data on any db. I use it in my day-to-day work... The instructions are pretty straightforward on the script, so have a look and let me know if you have questions. http://www.vim.org/scripts/script.php?script_id=356 Thanks Paul Stewart On 09/24/2012 09:54 AM, vicky b wrote: HI All, I am an enthusiastic vim fan but never used it much .I use sqldeveloper for db related tasks.Due you guys really feel comfortable in vim to write pl/sql and also can you guys also query the db and see the resutlset through vim. -- /*Thanks Regards Vickyb* / -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
On 09/24/12 11:54, vicky b wrote: I am an enthusiastic vim fan but never used it much .I use sqldeveloper for db related tasks.Due you guys really feel comfortable in vim to write pl/sql and also can you guys also query the db and see the resutlset through vim. While I don't use it regularly for Oracle/pl/sql, I do use it for T-SQL on SQL-Server for my day job. I don't use the dbext script that Paul mentions, but I don't usually use *any* scripts, so don't take it as a negative mark :-) I usually just use vim for easy formatting, and the power of :g and :s commands. I usually keep the master SQL in vim and copy into Query Analyzer to test. -tim -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
Thanks for the replies guys but in the present world where we leave with so much of ide and code completion and so many features what is that makes you guys stick to vim .. does it make your job simpler or features are great or your use to it. On Mon, Sep 24, 2012 at 10:47 PM, Tim Chase v...@tim.thechases.com wrote: On 09/24/12 11:54, vicky b wrote: I am an enthusiastic vim fan but never used it much .I use sqldeveloper for db related tasks.Due you guys really feel comfortable in vim to write pl/sql and also can you guys also query the db and see the resutlset through vim. While I don't use it regularly for Oracle/pl/sql, I do use it for T-SQL on SQL-Server for my day job. I don't use the dbext script that Paul mentions, but I don't usually use *any* scripts, so don't take it as a negative mark :-) I usually just use vim for easy formatting, and the power of :g and :s commands. I usually keep the master SQL in vim and copy into Query Analyzer to test. -tim -- *Thanks Regards Vickyb * -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
Actually, I do that too, I should've mentioned...I think the thing that I like about the dbext script is that I can do quick data validation before I cut and paste into other functions etc (if I'm embedding in a c# program or something similar)...I do like that with the script I can do all my work however without the need for any other editor... Paul On 09/24/2012 10:17 AM, Tim Chase wrote: On 09/24/12 11:54, vicky b wrote: I am an enthusiastic vim fan but never used it much .I use sqldeveloper for db related tasks.Due you guys really feel comfortable in vim to write pl/sql and also can you guys also query the db and see the resutlset through vim. While I don't use it regularly for Oracle/pl/sql, I do use it for T-SQL on SQL-Server for my day job. I don't use the dbext script that Paul mentions, but I don't usually use *any* scripts, so don't take it as a negative mark :-) I usually just use vim for easy formatting, and the power of :g and :s commands. I usually keep the master SQL in vim and copy into Query Analyzer to test. -tim -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
I should also mention that I use viemu on Visual Studio tooso I have a variety of tools to meet my needs www.viemu.com Paul On 09/24/2012 10:17 AM, Tim Chase wrote: On 09/24/12 11:54, vicky b wrote: I am an enthusiastic vim fan but never used it much .I use sqldeveloper for db related tasks.Due you guys really feel comfortable in vim to write pl/sql and also can you guys also query the db and see the resutlset through vim. While I don't use it regularly for Oracle/pl/sql, I do use it for T-SQL on SQL-Server for my day job. I don't use the dbext script that Paul mentions, but I don't usually use *any* scripts, so don't take it as a negative mark :-) I usually just use vim for easy formatting, and the power of :g and :s commands. I usually keep the master SQL in vim and copy into Query Analyzer to test. -tim -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
For me personally, number of reasons, but probably the main ones: --it is so small --it's fast --it's totally customizable (you can pretty much set it up exactly as you need/want it) --it works on pretty much every OS --once you get used to it is it incredibly fast to use...it's so much quicker than if you have to use the mouse...it frees your mind to concentrate on the code, not the editor --it's free!! There are many many other reasons, these are just a few of my own ones. Hope that helps...I would say give it a trypersonally, I don't think you'll go back to another editor once you get proficient on vim On 09/24/2012 10:19 AM, vicky b wrote: Thanks for the replies guys but in the present world where we leave with so much of ide and code completion and so many features what is that makes you guys stick to vim .. does it make your job simpler or features are great or your use to it. On Mon, Sep 24, 2012 at 10:47 PM, Tim Chase v...@tim.thechases.com mailto:v...@tim.thechases.com wrote: On 09/24/12 11:54, vicky b wrote: I am an enthusiastic vim fan but never used it much .I use sqldeveloper for db related tasks.Due you guys really feel comfortable in vim to write pl/sql and also can you guys also query the db and see the resutlset through vim. While I don't use it regularly for Oracle/pl/sql, I do use it for T-SQL on SQL-Server for my day job. I don't use the dbext script that Paul mentions, but I don't usually use *any* scripts, so don't take it as a negative mark :-) I usually just use vim for easy formatting, and the power of :g and :s commands. I usually keep the master SQL in vim and copy into Query Analyzer to test. -tim -- /*Thanks Regards Vickyb* / -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
On 09/24/12 12:19, vicky b wrote: Thanks for the replies guys but in the present world where we leave with so much of ide and code completion and so many features what is that makes you guys stick to vim .. does it make your job simpler or features are great or your use to it. First, I've used Vim for so long that I now find things like :w appearing in my other editing tools (Query Analyzer, Word, etc), so using Vim is habit. Also, the power of Vim makes it very easy to perform quick transformations on text/queries which I regularly do. For DB work, one I frequently do is a SELECT TOP 1 * FROM SomeTable and run it in text-mode (rather than grid-mode). I then copy out the headers in the results, paste them into Vim and issue a :s/\t/,\r/g to turn them into named columns that I can order as I see fit, without hand-entering them all. That often makes the foundation of a SELECT clause for me. Matching parens/braces, syntax highlighting, batch transforms, macros, etc. are all reasons I have trouble stepping away from Vim. -tim -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
look at that...I learn something new today :s/\t/,\r/g I didn't know that one...thanks On 09/24/2012 10:36 AM, Tim Chase wrote: On 09/24/12 12:19, vicky b wrote: Thanks for the replies guys but in the present world where we leave with so much of ide and code completion and so many features what is that makes you guys stick to vim .. does it make your job simpler or features are great or your use to it. First, I've used Vim for so long that I now find things like :w appearing in my other editing tools (Query Analyzer, Word, etc), so using Vim is habit. Also, the power of Vim makes it very easy to perform quick transformations on text/queries which I regularly do. For DB work, one I frequently do is a SELECT TOP 1 * FROM SomeTable and run it in text-mode (rather than grid-mode). I then copy out the headers in the results, paste them into Vim and issue a :s/\t/,\r/g to turn them into named columns that I can order as I see fit, without hand-entering them all. That often makes the foundation of a SELECT clause for me. Matching parens/braces, syntax highlighting, batch transforms, macros, etc. are all reasons I have trouble stepping away from Vim. -tim -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
On 09/24/12 12:45, Paul Stewart wrote: look at that...I learn something new today :s/\t/,\r/g I didn't know that one...thanks Granted, I'm lazy, so I've also been known to write SQL queries that return SQL queries as the result-set, and then run those in turn. :-) -tim -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Split windows and syntax highlighting
Hi Matthias! On Mo, 24 Sep 2012, Matthias Pitzl wrote: Hi there! Is it somehow possible to do a :syn off only for one specific window? Thanks in advance! Yes, if you use :setl syntax=off :syn off will turn off syntax highlighting globally. regards, Christian -- Der Aberglauben schlimmster ist, den seinen für den erträglicheren zu halten. -- Gotthold Ephraim Lessing (Nathan der Weise) -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: spam scripts on vim.org
Doak wrote: Is there no moderation for this? In any case they do appear to be spam. They are all by the same user, posted in quick succession on the same day, and the package files are all JPGs. With some strange content? ff d8 ff e0 00 10 4a 46 49 46 00 01 01 01 00 48 |..JFIF.H| 0010 00 48 00 00 ff fe 00 32 3c 3f 70 68 70 20 65 63 |.H.2?php ec| 0020 68 6f 28 6d 64 35 28 27 61 63 75 6e 65 74 69 78 |ho(md5('acunetix| 0030 2d 66 69 6c 65 2d 75 70 6c 6f 61 64 2d 74 65 73 |-file-upload-tes| 0040 74 27 29 29 3b 20 3f 3e ff db 00 43 00 05 03 04 |t')); ?...C| 0050 04 04 03 05 04 04 04 05 05 05 06 07 0c 08 07 07 || 0060 07 07 0f 0b 0b 09 0c 11 0f 12 12 11 0f 11 11 13 || I don't know much about jpeg, but imho this is not a regular content, is it? Looks like someone trying out if injecting PHP through an image works. Perhaps someone familiar with PHP vulnerabilities knows what is going on? Could be related to an SQL injection as well. -- ROBIN: The what? ARTHUR: The Holy Hand Grenade of Antioch. 'Tis one of the sacred relics Brother Maynard always carries with him. ALL:Yes. Of course. ARTHUR: (shouting) Bring up the Holy Hand Grenade! Monty Python and the Holy Grail PYTHON (MONTY) PICTURES LTD /// Bram Moolenaar -- b...@moolenaar.net -- http://www.Moolenaar.net \\\ ///sponsor Vim, vote for features -- http://www.Vim.org/sponsor/ \\\ \\\ an exciting new programming language -- http://www.Zimbu.org/// \\\help me help AIDS victims -- http://ICCF-Holland.org/// -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: spam scripts on vim.org
I wrote: Doak wrote: Is there no moderation for this? In any case they do appear to be spam. They are all by the same user, posted in quick succession on the same day, and the package files are all JPGs. With some strange content? ff d8 ff e0 00 10 4a 46 49 46 00 01 01 01 00 48 |..JFIF.H| 0010 00 48 00 00 ff fe 00 32 3c 3f 70 68 70 20 65 63 |.H.2?php ec| 0020 68 6f 28 6d 64 35 28 27 61 63 75 6e 65 74 69 78 |ho(md5('acunetix| 0030 2d 66 69 6c 65 2d 75 70 6c 6f 61 64 2d 74 65 73 |-file-upload-tes| 0040 74 27 29 29 3b 20 3f 3e ff db 00 43 00 05 03 04 |t')); ?...C| 0050 04 04 03 05 04 04 04 05 05 05 06 07 0c 08 07 07 || 0060 07 07 0f 0b 0b 09 0c 11 0f 12 12 11 0f 11 11 13 || I don't know much about jpeg, but imho this is not a regular content, is it? Looks like someone trying out if injecting PHP through an image works. Perhaps someone familiar with PHP vulnerabilities knows what is going on? Could be related to an SQL injection as well. Note that searching for acunetix-file-upload-test returns some interesting hints. -- An indication you must be a manager: You can explain to somebody the difference between re-engineering, down-sizing, right-sizing, and firing people's asses. /// Bram Moolenaar -- b...@moolenaar.net -- http://www.Moolenaar.net \\\ ///sponsor Vim, vote for features -- http://www.Vim.org/sponsor/ \\\ \\\ an exciting new programming language -- http://www.Zimbu.org/// \\\help me help AIDS victims -- http://ICCF-Holland.org/// -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: spam scripts on vim.org
Bram, just wanted to tell you that you are a celebrity in my book! I recently discovered how to use VIM help capabilities to organize my notes (it was out of need/necessity that I discovered it). Been using VIM for many years and always thought it was great but now I think it's INDISPENSIBLE!! Take care, Paul From: Bram Moolenaar b...@moolenaar.net To: Bram Moolenaar b...@moolenaar.net Cc: doak d...@gmx.de; vim_use@googlegroups.com; Benjamin Klein b...@silver-chalice.com Sent: Monday, September 24, 2012 4:45 PM Subject: Re: spam scripts on vim.org I wrote: Doak wrote: Is there no moderation for this? In any case they do appear to be spam. They are all by the same user, posted in quick succession on the same day, and the package files are all JPGs. With some strange content? ff d8 ff e0 00 10 4a 46 49 46 00 01 01 01 00 48 |..JFIF.H| 0010 00 48 00 00 ff fe 00 32 3c 3f 70 68 70 20 65 63 |.H.2?php ec| 0020 68 6f 28 6d 64 35 28 27 61 63 75 6e 65 74 69 78 |ho(md5('acunetix| 0030 2d 66 69 6c 65 2d 75 70 6c 6f 61 64 2d 74 65 73 |-file-upload-tes| 0040 74 27 29 29 3b 20 3f 3e ff db 00 43 00 05 03 04 |t')); ?...C| 0050 04 04 03 05 04 04 04 05 05 05 06 07 0c 08 07 07 || 0060 07 07 0f 0b 0b 09 0c 11 0f 12 12 11 0f 11 11 13 || I don't know much about jpeg, but imho this is not a regular content, is it? Looks like someone trying out if injecting PHP through an image works. Perhaps someone familiar with PHP vulnerabilities knows what is going on? Could be related to an SQL injection as well. Note that searching for acunetix-file-upload-test returns some interesting hints. -- An indication you must be a manager: You can explain to somebody the difference between re-engineering, down-sizing, right-sizing, and firing people's asses. /// Bram Moolenaar -- b...@moolenaar.net -- http://www.Moolenaar.net \\\ /// sponsor Vim, vote for features -- http://www.Vim.org/sponsor/ \\\ \\\ an exciting new programming language -- http://www.Zimbu.org /// \\\ help me help AIDS victims -- http://ICCF-Holland.org /// -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Split windows and syntax highlighting
On 24/09/12 19:56, Christian Brabandt wrote: Hi Matthias! On Mo, 24 Sep 2012, Matthias Pitzl wrote: Hi there! Is it somehow possible to do a :syn off only for one specific window? Thanks in advance! Yes, if you use :setl syntax=off or just :setl syntax= (with nothing after the = sign) If by any chance you had downloaded a syntax/off.vim in one of the directory trees part of 'runtimepath', :setl syntax=off would apply it to the current editfile. :syn off will turn off syntax highlighting globally. regards, Christian Best regards, Tony. -- Money is the root of all evil, and man needs roots -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: autocmd error in vim
On 24/09/12 16:14, rudra wrote: Hello friends, You may ignore this post. This problem is solved once I installed vi-enhanced. I only had vi-minimal before. But both were showing vim as version. On one of the :version lines you snipped, vim-minimal probably said Tiny version without GUI where vim-enhanced says Huge version without GUI (or maybe Big rather than Huge) and gvim (which you can also install together with the other two, and even run in console mode) Huge version with GTK2 GUI or similar. Tiny and Small builds of Vim have no expression evaluation, and that makes a huge difference. To them, anything from if to endif is a nestable comment, and outside of such a comment, a :let command gives an error. Best regards, Tony. -- No letters of the alphabet were harmed in the creation of this message. -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
On 24/09/2012 1:19 PM, vicky b wrote: Thanks for the replies guys but in the present world where we leave with so much of ide and code completion and so many features what is that makes you guys stick to vim .. does it make your job simpler or features are great or your use to it. I am the maintainer of dbext and a host of other related SQL support in Vim. IDE features provided by other software are great and a number of them have been added to Vim via plugins. SrchRplcHiGrp.vim : Search and/or replace based on a syntax highlight group http://www.vim.org/scripts/script.php?script_id=848 http://www.vim.org/scripts/script.php?script_id=848 Since I work with SQL all day, I primarily created it to UPPER CASE keywords (SELECT, UPDATE, FROM, WHERE, ...) in SQL. But, it has nothing to do with SQL. Basically, if Vim can colour highlight text in a file, then you can choose to search and replace on those colour highlights. I justchoose sqlKeyword highlighting keywords and then to do a search and replace to transform those words into UPPER CASE strings. There is also this plugin: SQLUtilities : SQL utilities - Formatting, generate - columns lists, procedures for databases http://www.vim.org/scripts/script.php?script_id=492 http://www.vim.org/scripts/script.php?script_id=492 The main purpose of this plugin is it will reformat SQL queries into a nice readable format. But it has another option which will allow you to UPPER CASE your keywords as well. Tim, I noticed you mentioned you format SQL, have a look at the web page for this plugin it shows a few formatting examples. dbext.vim : Provides database access to many dbms (Oracle, Sybase, Microsoft, MySQL, DBI,..) http://www.vim.org/scripts/script.php?script_id=356 http://www.vim.org/scripts/script.php?script_id=356 This one was mentioned by Paul. It can do far more than simply execute SQL. One of the most useful features I find is the ability to execute SQL and prompt you for input parameters. It can also do this for many different fileformats. For example assume you had the following Java code: String mySQL = SELECT s.script, ts.event, t.name + , s.script_language, sv.name + FROM ml_script s, ml_table_script ts, ml_table t + , ml_script_version sv + WHERE s.script_id = + script_version + AND ts.version= +obj.method() + AND ts.table_id = t.table_id ; If you visually select from the SELECT ... to the ; and ran :','DBExecSQL The Java filetype support would concatenate each individual string into one single string. In this case it removed the + and concatenated the lines to result in the following (assuming this is on one line): SELECT s.script, ts.event, t.name , s.script_language, sv.name FROM ml_script s, ml_table_script ts, ml_table t , ml_script_version sv WHERE s.script_id = + script_version + AND ts.version= +obj.method() + AND ts.table_id = t.table_id It will then prompt you for values for script_version and obj.method(). This allows you to execute the query and test it without having you to modify your code at all. A number of different filetypes are supported, Java, Perl, PHP, VB, Vim, SQL. More can be added. Included with Vim 7.3 is the SQL Complete plugin. It uses the OMNI completion built into Vim (CTRL-X CTRL-O) and will complete using SQL syntax keywords. If you have the dbext plugin installed, it will also complete, tables, columns, stored procedures and other items. It will dynamically pull these from whatever database you have it connect. See the help file :h omni-sql-completion or :h ft_sql.txt Tim, you also showed an example of how create a select column list by grabbing the headers (from a different program) and running a search and replace on it. SQLComplete.vim has provisions for doing just that. When on a table name, a key stroke will replace the table name with a comma separated list of columns from that table. Anyway, there is a bunch more to the SQL support I have added in Vim, but that should give people a fairly good overview. David. -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php
Re: Vim for Oracle
Hi David, Thanks for the info, I only use about 20% of the power of your plugins I'm sure. Thanks for maintaining them, they are a great help. Paul Stewart On 09/24/2012 07:18 PM, David Fishburn wrote: On 24/09/2012 1:19 PM, vicky b wrote: Thanks for the replies guys but in the present world where we leave with so much of ide and code completion and so many features what is that makes you guys stick to vim .. does it make your job simpler or features are great or your use to it. I am the maintainer of dbext and a host of other related SQL support in Vim. IDE features provided by other software are great and a number of them have been added to Vim via plugins. SrchRplcHiGrp.vim : Search and/or replace based on a syntax highlight group http://www.vim.org/scripts/script.php?script_id=848 http://www.vim.org/scripts/script.php?script_id=848 Since I work with SQL all day, I primarily created it to UPPER CASE keywords (SELECT, UPDATE, FROM, WHERE, ...) in SQL. But, it has nothing to do with SQL. Basically, if Vim can colour highlight text in a file, then you can choose to search and replace on those colour highlights. I justchoose sqlKeyword highlighting keywords and then to do a search and replace to transform those words into UPPER CASE strings. There is also this plugin: SQLUtilities : SQL utilities - Formatting, generate - columns lists, procedures for databases http://www.vim.org/scripts/script.php?script_id=492 http://www.vim.org/scripts/script.php?script_id=492 The main purpose of this plugin is it will reformat SQL queries into a nice readable format. But it has another option which will allow you to UPPER CASE your keywords as well. Tim, I noticed you mentioned you format SQL, have a look at the web page for this plugin it shows a few formatting examples. dbext.vim : Provides database access to many dbms (Oracle, Sybase, Microsoft, MySQL, DBI,..) http://www.vim.org/scripts/script.php?script_id=356 http://www.vim.org/scripts/script.php?script_id=356 This one was mentioned by Paul. It can do far more than simply execute SQL. One of the most useful features I find is the ability to execute SQL and prompt you for input parameters. It can also do this for many different fileformats. For example assume you had the following Java code: String mySQL = SELECT s.script, ts.event, t.name + , s.script_language, sv.name + FROM ml_script s, ml_table_script ts, ml_table t + , ml_script_version sv + WHERE s.script_id = + script_version + AND ts.version= +obj.method() + AND ts.table_id = t.table_id ; If you visually select from the SELECT ... to the ; and ran :','DBExecSQL The Java filetype support would concatenate each individual string into one single string. In this case it removed the + and concatenated the lines to result in the following (assuming this is on one line): SELECT s.script, ts.event, t.name , s.script_language, sv.name FROM ml_script s, ml_table_script ts, ml_table t , ml_script_version sv WHERE s.script_id = + script_version + AND ts.version= +obj.method() + AND ts.table_id = t.table_id It will then prompt you for values for script_version and obj.method(). This allows you to execute the query and test it without having you to modify your code at all. A number of different filetypes are supported, Java, Perl, PHP, VB, Vim, SQL. More can be added. Included with Vim 7.3 is the SQL Complete plugin. It uses the OMNI completion built into Vim (CTRL-X CTRL-O) and will complete using SQL syntax keywords. If you have the dbext plugin installed, it will also complete, tables, columns, stored procedures and other items. It will dynamically pull these from whatever database you have it connect. See the help file :h omni-sql-completion or :h ft_sql.txt Tim, you also showed an example of how create a select column list by grabbing the headers (from a different program) and running a search and replace on it. SQLComplete.vim has provisions for doing just that. When on a table name, a key stroke will replace the table name with a comma separated list of columns from that table. Anyway, there is a bunch more to the SQL support I have added in Vim, but that should give people a fairly good overview. David. -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php -- You received this message from the vim_use maillist. Do not top-post! Type your reply below the text you are replying to. For more information, visit http://www.vim.org/maillist.php