Monday, July 24, 2017

Re: Configure DBext mac for SQLite

On Monday, July 24, 2017 at 7:28:39 AM UTC-4, Brian Libgober wrote:
> Apologies if this is a repeat post, I have been trying to configure vim to work with dbext on MacOS Yosemite. Here's the connection string I have setup in my .vimrc
>
> And here's the command I run
>
> select * from CIK limit 5;
>
> The error I get back
>
> Connection: T(SQLITE) D(/Users/brianlibgober/Dropbox/Collaborations/CleanMake/Main.sqlite) at 17:32
> Error: near "<": syntax error
> To change connection parameters:
> :DBPromptForBufferParameters
> Or
> :DBSetOption user|passwd|dsnname|srvname|dbname|host|port|...=<value>
> :DBSetOption user=tiger:passwd=scott
> Last command(rc=1):
> sqlite3 /Users/brianlibgober/Dropbox/Collaborations/CleanMake/Main.sqlite < /var/folders/p2/nkftf47s5vb8zr6slgc7fc940000gn/T/v5uxPIb/dbext.sql
> Last SQL:
> .mode column
> .headers ON
> select * from CIK limit 5
>
> The bizarreness of this is that the following run on terminal:
>
> sqlite3 /Users/brianlibgober/Dropbox/Collaborations/CleanMake/Main.sqlite < /var/folders/p2/nkftf47s5vb8zr6slgc7fc940000gn/T/v5uxPIb/dbext.sql
>
> Yields
>
> index CIK COMPANYNAME
> ---------- ---------- -----------
> 0 0001438823 !J INC
> 1 0001509607 #1 A LIFESA
> 2 0001457512 #1 ARIZONA
> 3 0001433777 #1 PAINTBAL
> 4 0001427189 $ LLC
>
> Which is what I would expect....

Interestingly, the command :DBListTable does what it should, so the connection works...

--
--
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 because you are subscribed to the Google Groups "vim_use" group.
To unsubscribe from this group and stop receiving emails from it, send an email to vim_use+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment