column width in dbout is too large about vim-dadbod-ui HOT 9 CLOSED

sqlcmd will size the columns based on the field width up to a maximum (default 80) but only if it knows how long the field is. If you do some manipulation in the select statement it won't know how big the field is and will set it to the maximum. That's what's happening with the output of sp_help (which is why I added the Columns item in vim-dadbod-ui so it all fit nicely on the screen)
Its possible to pass parameters to sqlcmd "under the covers" using a an ini file. Search google for SQLCDMINI.

from vim-dadbod-ui.

from vim-dadbod-ui.

dbout output is completely handled by vim-dadbod.
I'm not sure if this can be configured somehow.
@pnetherwood do you maybe have some advice how to reduce width of the columns for mssql?

Autocompletion only autocompletes tables,schemas and columns. It is not a full completion framework.

from vim-dadbod-ui.

dbout output is completely handled by vim-dadbod.
I'm not sure if this can be configured somehow.
@pnetherwood do you maybe have some advice how to reduce width of the columns for mssql?

Autocompletion only autocompletes tables,schemas and columns. It is not a full completion framework.

OK.

Thanks for the quick reply.

from vim-dadbod-ui.

I came to know that in vim-dadbod the raw output from sqlcmd tool is printing into to dbout (in the case of mssql).
Should i have to write some parsing function on my own the can parse the dbout content or is there any other way ?

By the way @kristijanhusak , your vim-dadbod-ui is owesome.

from vim-dadbod-ui.

You should be able to provide custom width for columns. Check this comment:
#26 (comment)

And this SO question: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b6f2314c-1ecb-43fc-b881-2d2df7c9c457/setting-individual-column-width-in-sqlcmd-outut?forum=sqltools

I think combining these two should help you solve the issue.

from vim-dadbod-ui.

Thanks for the links. I am able to configure the columns width.

from vim-dadbod-ui.

@pnetherwood Yeah I have set ‘SQLCMDINI’ to use ‘init.sql’ which contains
:setvar SQLCMDCOLSEP "|"

:setvar SQLCMDMAXFIXEDTYPEWIDTH 20

:setvar SQLCMDMAXVARTYPEWIDTH 50

There is another option that we can usesqlcmd -W which remove trailing spaces in each column and it best fits to the screen.
But I’m not able to find the var that I need to set to get that functionality.

May I know which var I need to set to get best column width to fit nicely to the screen.

from vim-dadbod-ui.

Ok thank you.

from vim-dadbod-ui.