Customer-Vendor Reports via SQLite

[Lewis Balentine]

Thank you ... I have updated the PDF file to reflect that information.

I would not normally use Writer for a code editor. It occurred me 
someone might get the PDF file and try to paste from it ... I wanted to 
be sure the code to would work if they did. I was cutting and pasting 
the SQL code from Writer to verify it. I was puzzled by a several 
instances where I knew the code 'should' work but generated an error.

Cheers,

Lewis

On 05/09/2016 11:34 AM, Robert Heller wrote:
> At Mon, 9 May 2016 06:47:43 -0500 Lewis Balentine <lewis at keywild.com> wrote:
> http://www.keywild.com/DL/GNUCashSQLiteReports.pdf  (948 KBytes)
> Two points about your PDF file:
>
> 1) For CentOS / Fedora the extra things needed to be installed for SQLite are:
>
> sudo yum install libdbi-dbd-sqlite    (this is the driver required by GNUCash)
> sudo yum install sqlite               (this is the command line utility)
>
> (*I* had no interest in a GUI based SQLite database browser, so I made no
> attempt to figure out the CentOS / Fedora package names for sqliteman or
> sqlitebrowser.)
>
> 2) And yes, one *never* uses a word processor as a code editor -- that will
> just about always cause trouble :-). *I* use JASSPA MicroEMacs (from
> http://www.jasspa.com/). Other options include GNU Emacs or vi (at least in
> the UNIX/Linux world).
>
>