Re: Configure DBext mac for SQLite

Managed to get the DBI interface to work. Had to recompile my vim against a version of perl with the necessary packaged installed, after doing that it worked immediately.

On Monday, July 24, 2017 at 1:51:27 PM UTC-4, Brian Libgober wrote:
> 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.