Re: SQL completion questions/bug?

On Tue, Dec 22, 2009 at 10:57 AM, Benjamin R. Haskell <vim@benizi.com> wrote:
> On Tue, 22 Dec 2009, Benjamin R. Haskell wrote:
...
>>
>> insert into tablen<C-C>t
>>
>> yielding:
>>
>> insert into tablename
>>
>> I get:
>>
>> insert into database_name.tablename
...
> Answering my own question, partly...
>
> I found the g:omni_sql_include_owner parameter, which defaults to 0 if
> it's unset, except that it then defaults to 1 if 'dbext' is also loaded.

Hmmm, I think it should default to off (0) in all cases. I will make
some updates and fire these off to Bram for sqlcomplete and dbext.

> Not sure of the 'owner' nomenclature... why not 'schema' or 'database'?
> Either way, adding the following to something sourced from .vimrc worked:

As you can see dbext supports > 10 databases. They all have different
names and conventions. M$ SQL Server uses:
database_name.schema_owner.table_name.
I picked one I thought would work across the masses. Once set, it is
fire and forget anyway.

Dave

> let g:omni_sql_include_owner = 0

Just about to tell you about that option :-)

--
You received this message from the "vim_use" maillist.
For more information, visit http://www.vim.org/maillist.php