Mercurial > vim

comparison runtime/doc/ft_sql.txt @ 2207:b17bbfa96fa0 vim73

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add the settabvar() and gettabvar() functions. Various runtime file updates.
author Bram Moolenaar <bram@vim.org>
date Sat, 22 May 2010 15:37:44 +0200
parents 7c8c7c95a865
children 0a258a67051d
comparison
equal deleted inserted replaced
2206:a8afba7027ae 2207:b17bbfa96fa0
534 clears the SQL completion cache. 534 clears the SQL completion cache.
535 - NOTE: <Right> and <Left> have been designed to work while the 535 - NOTE: <Right> and <Left> have been designed to work while the
536 completion window is active. If the completion popup window is 536 completion window is active. If the completion popup window is
537 not active, a normal <Right> or <Left> will be executed. 537 not active, a normal <Right> or <Left> will be executed.
538 538
539 Lets look how we can build a SQL statement dynamically. A select statement 539 Let's look at how we can build a SQL statement dynamically. A select statement
540 requires a list of columns. There are two ways to build a column list using 540 requires a list of columns. There are two ways to build a column list using
541 the SQL completion plugin. > 541 the SQL completion plugin. >
542 One column at a time: 542 One column at a time:
543 < 1. After typing SELECT press <C-C>t to display a list of tables. 543 < 1. After typing SELECT press <C-C>t to display a list of tables.
544 2. Choose a table from the list. 544 2. Choose a table from the list.
736 4.6 Using with other filetypes *sql-completion-filetypes* 736 4.6 Using with other filetypes *sql-completion-filetypes*
737 ------------------------------ 737 ------------------------------
738 738
739 Many times SQL can be used with different filetypes. For example Perl, Java, 739 Many times SQL can be used with different filetypes. For example Perl, Java,
740 PHP, Javascript can all interact with a database. Often you need both the SQL 740 PHP, Javascript can all interact with a database. Often you need both the SQL
741 completion as well as the completion capabilities for the current language you 741 completion and the completion capabilities for the current language you are
742 are editing. 742 editing.
743 743
744 This can be enabled easily with the following steps (assuming a Perl file): > 744 This can be enabled easily with the following steps (assuming a Perl file): >
745 1. :e test.pl 745 1. :e test.pl
746 2. :set filetype=sql 746 2. :set filetype=sql
747 3. :set ft=perl 747 3. :set ft=perl